Formulas and Functions

Function Description
“INT” (page 178 ) The INT function returns the nearest integer that
is less than or equal to the number.
“LCM” (page 179 ) The LCM function returns the least common
multiple of the specied numbers.
“LN” (page 179 ) The LN function returns the natural logarithm of
a number, the power to which e must be raised
to result in the number.
“LOG” (page 180) The LOG function returns the logarithm of a
number using a specied base.
“LOG10” (page 181) The LOG10 function returns the base-10
logarithm of a number.
“MOD” (page 182) The MOD function returns the remainder from a
division.
“MROUND” (page 183) The MROUND function rounds a number to the
nearest multiple of a specied factor.
“MULTINOMIAL” (page 184) The MULTINOMIAL function returns the closed
form of the multinomial coecient of the given
numbers.
“ODD” (page 185) The ODD function rounds a number away from
zero to the next odd number.
“PI” (page 186) The PI function returns the approximate value of
π (pi), the ratio of a circle’s circumference to its
diameter.
“POWER” (page 186) The POWER function returns a number raised to
a power.
“PRODUCT” (page 187) The PRODUCT function returns the product of
one or more numbers.
“QUOTIENT” (page 188) The QUOTIENT function returns the integer
quotient of two numbers.
“RAND” (page 189) The RAND function returns a random number
that is greater than or equal to 0 and less than 1.
“RANDBETWEEN” (page 189) The RANDBETWEEN function returns a random
integer within the specied range.
“ROMAN” (page 190) The ROMAN function converts a number to
Roman numerals.
168 Chapter 8 Numeric Functions