Microsoft Office Tutorials and References

In Depth Information

LCM

Returns the least common multiple.

LN

Returns the natural logarithm of a number.

LOG

Returns the logarithm of a number to a specified base.

LOG10

Returns the base 10 logarithm of a number.

MDETERM

Returns the matrix determinant of an array.

MINVERSE

Returns the matrix inverse of an array.

MMULT

Returns the matrix product of two arrays.

MOD

Returns the remainder from division.

MROUND

Returns a number rounded to the desired multiple.

MULTINOMIAL

Returns the multinomial of a set of numbers.

MUNIT***

Returns the unit matrix or the specified dimension.

ODD

Rounds a number up to the nearest odd integer.

PI

Returns the value of Π.

POWER

Returns the result of a number raised to a power.

PRODUCT

Multiplies its arguments.

QUOTIENT

Returns the integer portion of a division.

RADIANS

Converts degrees to radians.

RAND

Returns a random number between 0 and 1.

RANDBETWEEN Returns a random number between the numbers that you specify.

ROMAN

Converts an Arabic numeral to Roman, as text.

ROUND

Rounds a number to a specified number of digits.

ROUNDDOWN

Rounds a number down, toward zero.

ROUNDUP

Rounds a number up, away from zero.

SEC***

Returns the secant of an angle.