Excel Reference 549LOG LOG(number, base) returns the logarithm of number,
with the specifi ed (optional, default is 10) base.
LOG10 LOG10(number) returns the common logarithm
of number.
MOD MOD(number, divisor) returns the remainder of
the division of number by divisor.
MULTINOMIAL MULTINOMIAL(number1, number2,.. .)
returns the quotient of the factorial of the sum
of numbers and the product of the factorials of
numbers.
ODD ODD(number) returns number rounded up to the
nearest odd integer.
POWER POWER(number, power) returns number raised
to the power.
PERMUT PERMUT(x, n) returns the number of
permutations of x items taken n at a time.
RAND RAND() returns a randomly chosen number from
0 to but not including 1.
ROUND ROUND(number, places) rounds number to a
certain number of decimal places (if places is
positive), or to an integer (if places is 0), or to the
left of the decimal point (if places is negative).
ROUNDDOWN ROUNDDOWN(number, places) rounds like
ROUND, except always toward 0.
ROUNDUP ROUNDUP(number, places) rounds like ROUND,
except always away from 0.
SERIESSUM SERIESSUM(x, n, m, coeffi cients) returns the
sum of the power series
a 1 xn 1 a 2 xn^1 m 1 c 1 aixn^11 i^212 m, where
a 1 , a 2 ,... ai are the coeffi cients.
SIGN SIGN(number) returns 0, 1, or 21 , the sign of
number.
SQRT SQRT(number) returns the square root of
number.
SQRTPI SQRTPI(number) returns the square root of
number*p.
TRIM TRIM(text) returns text with spaces removed,
except for single spaces between words.
TRUNC TRUNC(number, digits) truncates number to an
integer (optionally, to a number of digits).