[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
GCD ( argument-list )
Description: Computes the greatest common divisor of the one or more numbers, designated by arguments in argument-list.
Arguments:
Name |
Type |
Description |
argument-list |
numbers |
The arguments in argument-list designate the values. Each argument is truncated to an integer. |
Return Type and Value: number – The greatest common divisor of one or more numbers.
However, if any argument is negative, #NUM! is returned.
[Example:
GCD(5) results in 5
GCD(5,2) results in 1
GCD(100,50,28) results in 2
GCD(24.5,36.3) results in 12
GCD(7,1) results in 1
GCD(5,0) results in 5
end example]