Microsoft Office Tutorials and References
In Depth Information
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.
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.
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.
LN The LN function returns the natural logarithm of a number. Natural logarithms are based on
the constant (2.71828182845904).
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.