Microsoft Office Tutorials and References

In Depth Information

**Math and Trigonometry Functions**

Returns the least common multiple of integers.

LCMN

Returns the natural logarithm of a number.

LN

Returns the logarithm of a number to the base you specify.

LOG

Returns the base 10 logarithm of a number.

LOG10

Returns the matrix determinant of an array.

MDETERM

Returns the inverse matrix for the matrix stored in an array.

MINVERSE

Returns the matrix product of two arrays.

MMULT

Returns the remainder after number is divided by divisor.

MOD

Returns number rounded to the desired multiple.

MROUND

Returns the ratio of the factorial of a sum of values to the product

of factorials.

MULTINOMIAL

Returns number rounded to the nearest odd integer.

ODD

Returns the number 3.14159265358979, the mathematical

constant pi, accurate to 15 digits. There are no arguments

associated with this function.

PI

Returns the result of a number raised to a power.

POWER

Multiplies all the numbers given as arguments and returns the

product.

PRODUCT

Returns the integer portion of a division.

QUOTIENT

Converts degrees to radians.

RADIANS

Returns an evenly distributed number greater than or equal to 0

and less than 1. There are no arguments associated with this

function.

RAND

Returns a random number between the numbers you specify.

RANDBETWEEN

Converts an Arabic numeral to Roman, as text.

ROMAN

Rounds a number to a specified number of digits.

ROUND

Rounds a number down toward 0.

ROUNDDOWN

Rounds a number up away from 0.

ROUNDUP

Returns the sum of a power series based on the formula.

SERIESSUM

Determines the sign (positive or negative) of number.

SIGN

Returns the sine of the given angle.

SIN

Returns the hyperbolic sine of number.

SINH

Returns the positive square root of number.

SQRT

Returns the square root of (number*pi).

SQRTPI