Microsoft Office Tutorials and References
In Depth Information
Math and Trigonometry Functions
Returns the least common multiple of integers.
Returns the natural logarithm of a number.
Returns the logarithm of a number to the base you specify.
Returns the base 10 logarithm of a number.
Returns the matrix determinant of an array.
Returns the inverse matrix for the matrix stored in an array.
Returns the matrix product of two arrays.
Returns the remainder after number is divided by divisor.
Returns number rounded to the desired multiple.
Returns the ratio of the factorial of a sum of values to the product
Returns number rounded to the nearest odd integer.
Returns the number 3.14159265358979, the mathematical
constant pi, accurate to 15 digits. There are no arguments
associated with this function.
Returns the result of a number raised to a power.
Multiplies all the numbers given as arguments and returns the
Returns the integer portion of a division.
Converts degrees to radians.
Returns an evenly distributed number greater than or equal to 0
and less than 1. There are no arguments associated with this
Returns a random number between the numbers you specify.
Converts an Arabic numeral to Roman, as text.
Rounds a number to a specified number of digits.
Rounds a number down toward 0.
Rounds a number up away from 0.
Returns the sum of a power series based on the formula.
Determines the sign (positive or negative) of number.
Returns the sine of the given angle.
Returns the hyperbolic sine of number.
Returns the positive square root of number.
Returns the square root of (number*pi).