Apple Numbers '08 User Manual

Page 243

Advertising
background image

Chapter 12

Dictionary of Functions

243

LCM

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.

Examples

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.

Examples

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).

Advertising