179 lcm 179 ln – Apple iWork '09 User Manual

Page 179

Advertising
background image

Chapter 8

Numeric Functions

179

LCM

The LCM function returns the least common multiple of the specified 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 specified 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 177

“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 defined, but

Â

because of floating-point rounding, =LN(EXP(x)) may not give exactly x.

Advertising