Formulas and Functions

Chapter 8 Numeric Functions 179
LCM
The LCM function returns the least common multiple of the specied numbers.
LCM(num-value, num-value…)
 num-value: A number. num-value is a number value.
 num-value…:Optionally include one or more additional numbers.
Usage Notes
Sometimes called the lowest or smallest common multiple, the least common Â
multiple is the smallest integer that is a multiple of the specied numbers.
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).
Related Topics
For related functions and additional information, see:
“GCD” on page 17 7
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
LN
The LN function returns the natural logarithm of a number, the power to which e must
be raised to result in the number.
LN(pos-num)
 pos-num: A positive number. pos-num is a number value and must be greater than 0.
Usage Notes
EXP and LN are mathematically inverses over the domain where LN is dened, but Â
because of oating-point rounding, =LN(EXP(x)) may not give exactly x.