Apple numbers User Manual

 Dictionary of Functions

 

  

The LCM function finds the least common multiple of the specified numbers. 
Sometimes called the lowest or smallest common multiple, the least common multiple 
is the smallest integer that is a multiple of the specified numbers.

LCM(number, [number, . . .])

 number:  Zero or one or more positive numbers or numeric expressions, or references 

to cells containing positive numbers or numeric expressions. Fractional parts are 
ignored. Negative numbers are not allowed.

  

Given the following table: 
  

LARGE(A2:E2, 1) returns 50, the largest value in the range.

LARGE(A2:E2, 2) returns 40, the second-largest value in the range.

LARGE(A2:E2, 5) returns 10, the fifth-largest value in the range.

LARGE(A2:E2) displays an error; you must specify n.

LARGE(A2:E2, 0) displays an error; n must be greater than 0.

LARGE(A2:E2, 6) displays an error; you can’t find the sixth out of five values.

LCM(2, 3) returns 6.

LCM(34, 68) returns 68.

LCM(30, 40, 60) returns 120.

LCM(30.25, 40.333, 60.5) returns 120 (the fractional parts are ignored).

LCM(2, -3) displays an error (negative numbers are not allowed).