[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

GCD

Syntax:

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]