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
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
Search JabSto ::

Custom Search