Microsoft Office Tutorials and References

In Depth Information

**LCM**

You also can use the
TRUNC
function.
INT
and
TRUNC
operate the same for positive numbers.

With negative numbers
INT
rounds away from zero and
TRUNC
rounds toward zero.

The
NUMBER
argument is the real number you want to round down

to an integer.

NUMBER

LCM
The
LCM
function returns the least common multiple of integers. The least common multiple

is the smallest positive integer that is a multiple of all integer arguments number1, number2,

and so on. Use
LCM
to add fractions with different denominators.

=LCM(number1,number2, ...)

This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if the

box for that add-in is checked. If it is not in the add-in list, run Setup to install it. For example,

LCM(16,28)
equals
112
.

The
NUMBER
arguments are 1 to 29 values. If any value is not an

integer, it is truncated. If any argument is 0, it is ignored. If any

argument is nonnumeric or less than 0, an error value is

returned. You also can use ranges of values in place of single

number values in this function.

NUMBER

LN
The
LN
function returns the natural logarithm of a number. Natural logarithms are based on

the constant (2.71828182845904).

=LN(number)

The
LN
function can be used in problems that calculate exponential growth, such as the

population growth in Figure 10.16. In this example, the cells are named cells. You can access the

CD and plug numbers into the cells in the live workbook instead of recreating this example.

NUMBER
The
NUMBER
argument is the positive real number for which you

want the natural logarithm.

LN
is the inverse of the
EXP
function, so the formula
LN(EXP(22.3))
equals
22.3
. You also can

use
LOG
if a more flexible approach is needed.