Formulas and Functions

Table Of Contents
Chapter 8 Numeric Functions 177
TRUNC on page 204
“More on Rounding” on page 355
Listing of Numeric Functions on page 167
Value Types” on page 36
The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
GCD
The GCD function returns the greatest common divisor of the specied numbers.
GCD(num-value, num-value…)
 num-value: A number. num-value is a number value. If there is a decimal portion it
is ignored.
 num-value…:Optionally include one or more additional numbers.
Usage Notes
Sometimes called the greatest common factor, the greatest common divisor is the Â
largest integer that divides into each of the numbers with no remainder.
Examples
=GCD(8, 10) returns 2.
=GCD(99, 102, 105) returns 3.
=GCD(34, 51) returns 17.
Related Topics
For related functions and additional information, see:
LCM on page 179
Listing of Numeric Functions on page 167
Value Types” on page 36
The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41