Function 
Description 
See detail 
Mathematics and trigonometric
functions 
ABS(number) 
Returns
the absolute value of a number 

RAND()

Returns
a number between 0 and 1 

COMBIN(number,number_chosen) 
Returns
a number of combinations for a determined number of elements 

COS(number)

Returns
the cosinus of an number 

INT(number) 
Rounds the
number off to the nearest integer 

EXP(number)

Performs
the calculation to elevate "e" to the power of a determined
number 

FACT(number) 
Returns the factorial of a number 

ROMAN(number,form)

Converts an arabic numeral to roman, as
text.


PI() 
Returns the number 3.14159265358979, the
mathematical constant pi, accurate to 15 digits.


POWER(number;power) 
Returns the result of a number raised to
a power.


PRODUCT(number1;number2;...) 
Multiplies all the numbers given as arguments
and returns the product 

SQRT(number)

Returns a positive square root.


MOD(number;divisor) 
Returns
the rest of the division 

Statistics functions 
HARMEAN(number1;number2;...) 
Reurns the
harmonic mean of a data set 

MAX(number1;number2;...)

Returns
the maximum value of a list of values 

MIN(number1;number2;...)

Returns
the maximum value of a list of values 

MEDIAN(number1;number2;...)

Returns the median of the given numbers.


MODE(number1;number2;...)

Returns the most frequently occurring, or
repetitive, value in an array or range of data. 

AVERAGE(number1;number2;...)

Returns the average (arithmetic mean) of
the arguments. 

VAR(number1;number2;...)

Estimates variance based on a sample.


LARGE(array;k) 
Returns
the kth largest value in a data set 

SMALL(array;k) 
Returns
the kth smallest value in a data set 

Logical functions 
FALSE() 
Returns the logical value FALSE


TRUE() 
Returns the logical value TRUE 

IF(logical_test,value_if_true,value_if_false)

Returns one value if a condition you specify
evaluates to TRUE and another value if it evaluates to FALSE.


NOT(logical_value)

Reverses the value of its argument. 

AND(logical_value1;logical_value2;...) 
Returns TRUE if all its arguments are TRUE


OR(logical_value1;logical_value2;...) 
Returns TRUE if any argument is TRUE


Information functions

ISBLANK(value) 
Returns TRUE if the value is blank


ISERR(value) 
Returns TRUE if the value is any error value
except #N/A


ISLOGICAL(value)

Returns TRUE if the value is a logical value


ISNONTEXT(valor)

Returns TRUE if the value is not text


ISTEXT(value) 
Returns TRUE if the value is text


ISNUMBER(value) 
Returns TRUE if the value is a number


TYPE(value) 
Returns a number indicating the data type
of a value 
