| Name: | ABS |
| Syntax: | ABS(<number>) |
| Description: | Returns the absolute value of the number argument. This is the argument without its sign. |
| Version: | 1.0 |
| Example: | ABS(-1) Equates to 1 ABS(-1.5) Equates to 1.5 ABS(1) Equates to 1 ABS(1.5) Equates to 1.5 |
| Name: | CEILING |
| Syntax: | CEILING(<number>,<significance>) |
| Description: | Returns the number rounded up (away from zero) to the nearest multiple of significance. |
| Version: | 1.0 |
| Example: | CEILING(-1.1, -1) Equates to 2 CEILING(-1, -3) Equates to 3 CEILING(1.16, 0.1) Equates to 1.2 |
| Name: | EVEN |
| Syntax: | EVEN(<number>) |
| Description: | Returns the nearest even number which is numerically higher than the single number argument. |
| Version: | 1.0 |
| Example: | EVEN(-1) Equates to -2 EVEN(-0.9) Equates to -2 EVEN(0.9) Equates to 2 EVEN(1) Equates to 2 |
| Name: | EXP |
| Syntax: | EXP(<number>) |
| Description: | Returns the exponential of the number argument. This is e to the power of n, where e is Euler’s number (approximately 2.718281828) |
| Version: | 1.0 |
| Example: | EXP(0) Evaluates to 1 EXP(1) Evaluates to 2.71828183 EXP(2) Evaluates to 7.38905609 |
| Name: | FACT |
| Syntax: | FACT(<number>) |
| Description: | Returns the factorial of the single number passed in. Returns an error if the argument does not evaluate to a number. |
| Version: | 1.0 |
| Example: | FACT(0) Evaluates to 1 FACT(1) Evaluates to 1 FACT(4) Evaluates to 24 |
| Name: | FLOOR |
| Syntax: | FLOOR(<number>,<significance>) |
| Description: | Returns the number rounded down (towards zero) to the nearest multiple of significance. |
| Version: | 1.0 |
| Example: | FLOOR(-1.1,-1) Equates to -1 FLOOR(2, 2.5) Equates to 0 FLOOR(2.16,0.1) Equates to 2.1 |
| Name: | INT |
| Syntax: | INT(<number>) |
| Description: | Rounds a number down to the nearest integer. |
| Version: | 1.3 |
| Name: | LN |
| Syntax: | LN(<number>) |
| Description: | Returns the natural logarithm of the number passed in. Returns an error if the argument does not evaluate to a number. |
| Version: | 1.0.2 |
| Example: | LN(1) Equates to 0 LN(10) Equates to 2.3 |
| Name: | LOG |
| Syntax: | LOG(<number>[,<base>]) |
| Description: | Returns the logarithm of the number passed in. If the base is not specified in the second argument then base-10 is used. Returns an error if the argument does not evaluate to a number. |
| Version: | 1.0 |
| Example: | LOG(1) Equates to 0 LOG(10,2) Equates to 3.3 |
| Name: | LOG10 |
| Syntax: | LOG10(<number>) |
| Description: | Returns the base-10 logarithm of the number passed in. Returns an error if the argument does not evaluate to a number. |
| Version: | 1.0 |
| Example: | LOG10(1) Equates to 0 LOG10(10) Equates to 1 |
| Name: | MAX |
| Syntax: | MAX(<numbers>[,< numbers >]*) |
| Description: | Returns the minimum value of all the number arguments. References to empty and non-number cells are ignored. |
| Version: | 1.0 |
| Example: | MAX(A1:C3) MAX(A1,B2,B3) MAX(1.2,2.3,3.4) Evaluates to 3.4 MAX(2*3, SUM(A1,A2)) |
| Name: | MIN |
| Syntax: | MIN(<numbers>[,< numbers >]*) |
| Description: | Returns the minimum value of all the number arguments. References to empty and non-number cells are ignored. |
| Version: | 1.0 |
| Example: | MIN(A1:C3) MIN(A1,B2,B3) MIN(1.2,2.3,3.4) Evaluates to 1.2 MIN(2*3, SUM(A1,A2)) |
| Name: | MOD |
| Syntax: | MOD(<number>,<divisor>) |
| Description: | Returns the modulus of the passed in number. The first argument is the number for which you want to find the remainder. The second argument is the number by which you want to divide the number. |
| Version: | |
| Example: | MOD(12,5) evaluates to 2 |
| Name: | ODD |
| Syntax: | ODD(<number>) |
| Description: | Returns the nearest odd number which is numerically higher than the single number argument. |
| Version: | 1.0 |
| Example: | ODD(-1) Equates to -1 ODD(-0.9) Equates to -1 ODD(0.9) Equates to 1 ODD(1) Equates to 1 ODD(1.1) Equates to 3 |
| Name: | PI |
| Syntax: | PI() |
| Description: | Returns the value of PI (the ratio of the diameter to the circumference of a circle) to ten decimal places. |
| Version: | 1.0 |
| Example: | PI() Evaluates to 3.1415926536 |
| Name: | POWER |
| Syntax: | POWER(<number>, <number>) |
| Description: | Returns a number which is the first number argument raised to the power of the second number argument. Returns an error if either argument does not evaluate to a number. |
| Version: | 1.0 |
| Example: | POWER(10, 2) Evaluates to 100 POWER(B2, 2) |
| Name: | PRODUCT |
| Syntax: | PRODUCT(<numbers>[,< numbers >]*) |
| Description: | Returns a number which is the product of all number arguments. References to empty and non-number cells are ignored. |
| Version: | 1.1 |
| Example: | PRODUCT(A1:C3) PRODUCT(A1,B2,B3) PRODUCT(1.2,2.3,3.4) PRODUCT(2*3, MIN(A1,A2)) |
| Name: | RAND |
| Syntax: | RAND() |
| Description: | Returns a random number greater or equal to zero and less than 1. Changes on recalculation. |
| Version: | 3.0 |
| Name: | ROUND |
| Syntax: | ROUND(<number>,<number>) |
| Description: | Rounds the first argument to the number of decimal places specified in the second argument. |
| Version: | 1.0 |
| Example: | ROUND(1.54,1) Equates to 1.5 |
| Name: | ROUNDDOWN |
| Syntax: | ROUNDDOWN(<number>, <digits>) |
| Description: | Round a number down. |
| Version: | 2.0 |
| Example: | ROUNDDOWN(1.239,2) Evaluates to 1.23 |
| Name: | ROUNDUP |
| Syntax: | ROUNDUP(<number>, <digits>) |
| Description: | Round a number up. |
| Version: | 2.0 |
| Example: | ROUNDUP(1.231,2) Evaluates to 1.24 |
| Name: | SIGN |
| Syntax: | SIGN(<number>) |
| Description: | Returns the sign of a number: 1 if the number is positive, zero if the number is zero and -1 if the number is negative. |
| Version: | 3.0 |
| Name: | SQRT |
| Syntax: | SQRT(<number>) |
| Description: | Returns a number which is the square root of the single number argument. Returns an error if the argument does not evaluate to a non-negative number. |
| Version: | 1.0 |
| Example: | SQRT(9) Equates to 3 SQRT(C3) SQRT(POWER(2, 2)) |
| Name: | SQRTPI |
| Syntax: | SQRTPI(number) |
| Description: | Returns the square root of (number * pi). |
| Version: | 1.3 |
| Name: | SUM |
| Syntax: | SUM(<numbers>[,<numbers>]*) |
| Description: | Returns a number which is the sum of all number arguments. References to empty and non-number cells are ignored. |
| Version: | 1.0 |
| Example: | SUM(A1:C3) SUM(A1,B2,B3) SUM(1.2,2.3,3.4) SUM(2*3, MIN(A1,A2)) |
| Name: | SUMIF |
| Syntax: | SUMIF(<range>, <criteria> [, <sum_range>]) |
| Description: | Returns the sum of cells in the first argument reference/range that match the criteria in the second argument. An optional third argument can secify the cells containing the actual values to sum. |
| Version: | 3.0.1 |
| Example: | SUMIF(A1, ">0") SUMIF(A1:C5, "a*", D1) SUMIF(A1:C5, "<>0", D1:F5) |
| Name: | SUMPRODUCT |
| Syntax: | SUMPRODUCT(<array>[,<array>]*) |
| Description: | Returns a number which is the sum of the products of each member of each array argument. If the arrays are not all the same size, an error is returned. |
| Version: | 1.1 |
| Example: | SUMPRODUCT(a1:a2,b1:b2) evaluates to ((a1*b1)+(a2*b2)) |
| Name: | TRUNC |
| Syntax: | TRUNC(number[,num_digits]) |
| Description: | Truncates a number to an integer by removing the fractional part of the number. |
| Version: | 1.3 |