In This Topic

LCM

In This Topic

This function returns the least common multiple of two numbers.

LCM(*number1*,*number2*)

For the arguments, use numeric values or arrays. If the arguments are not integers, they are truncated to integers. This function can have up to 255 arguments.

The least common multiple is the smallest positive integer that is a multiple of all integers given.

Use this function to add fractions with different denominators by calculating the least common multiple of both denominators first.

Accepts numeric data for all arguments. Returns numeric data.

LCM(B12,C22)

LCM(R12C2,R22C3)

LCM(300,500) gives the result 1500

LCM(12.3,16.99) gives the result 48

This function is available in product version 1.0 or later.

GCD | Math and Trigonometry Functions