Besides the previousely mentioned functions, a wide range of functions exist for different categories, all of which can be of great assistance.
In this chapter we will cover a few of theses functions, all classified by category.
| 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 k-th largest value in a data set |
|
| SMALL(array;k) | Returns
the k-th 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 |
|
You can practise some of the functions explained here in the 
