[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

LCM

Syntax:

LCM ( argument-list )

Description: Computes the least common multiple of the one or more arguments in argument-list.

Arguments:

Name

Type

Description

argument-list

number

argument-list specifies the arguments. Each argument is truncated to an integer.

 

Return Type and Value: number – The least common multiple of one or more numbers.

However, if any argument is negative, #NUM! is returned.

[Example:

LCM(5) results in 5
LCM(5,2) results in 10
LCM(24.99,36.45) results in 72
LCM(24,36,15) results in 360

end example]