[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]