Site hosted by Angelfire.com: Build your free website today!

Other Functions

Function Basics Insert Function AutoSum IF Function
PMT Function Date Functions DATEDIF Function Lookup Functions
New 07 Functions Time Functions Text Functions Rounding Functions
Stat Functions Other Functions SUBTOTAL (.xls) SUMPRODUCT (.xls)
PI
Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
Syntax: PI()
SQRT
Returns a positive square root of a number.
Syntax: SQRT(number)
RAND
Returns a random number between 0 and 1.
Syntax: RAND()
RANDBETWEEN
Returns a random number between the numbers you specify.
Syntax: RANDBETWEEN(bottom, top)
CHAR
Returns the character specified by a code number.
Syntax: CHAR(code number)
Code number is a number between 1 and 255 specifying the desired character. Characters are from the ANSI character set on a Windows computer.

Return to the Top