Math functions perform simple and complex mathematical calculations.
Reminder: The arguments in virtually all functions can be either an actual value or a reference to a cell with a value. For example, ABS (C4) returns the absolute value of the number in cell C4. Cell C4 can be a formula as well thus building an interrelationship between many cells in the table. However, be careful to avoid circular references (formulas that refer to cells that ultimately refer to the original cell).
|
Negative numbers will be made positive; positive numbers will be returned unchanged.
| |
|
Averages the given expressions (adds up all the expressions and divides the outcome by the number of expressions added). If an expression evaluates to a range of cells all the values in the range are averaged. Text in ranges are ignored. If an error condition is encountered in a range of cells, the average function errors as well.
| |
|
Computes the total number of unique combinations for a defined collection. Fractional parts are ignored. Negative numbers in cause an error.
| |
|
Counts the number of given expressions. If an expression evaluates to a range of cells all the values in the range are counted. Text in ranges are ignored.
| |
|
Returns an approximate value for e raised to the given power. Where e is the base of the natural logarithms.
| |
|
Returns the factorial value for the given integer. The factorial value is given by multiplying the integers between 1 and the given number to each other. FACT(0) is defined as 1.
| |
|
Returns the fractional part of a given number.
| |
|
Returns the integer value closest to the given value. The resulting integer is equal to or less than, but not greater than the given value. If value is positive the fractional portion of the number is truncated. If the value is negative it is rounded down to the next lowest whole number.
| |
|
The natural logarithm for a value.
| |
|
Returns the base-x logarithm of the given number where x is base.
| |
|
Returns the base-10 logarithm of the given number. .
| |
|
Returns the largest number in a given list of arguments. If an expression references a range of cells, all the cells in the range are compared.
| |
|
Returns the smallest number in a given list of arguments. If an expression references a range of cells, all the cells in the range are compared.
| |
|
Returns the remainder of a fractional division.
| |
|
Multiplies the given expressions. If an expression evaluates to a range of cells, all the values in the range are multiplied. Text in ranges is ignored. If an error condition is encountered in a range of cells, the PRODUCT function returns an error as well.
| |
|
Returns the quotient of fractional division.
| |
|
Returns a random number.
| |
|
Returns the quotient of fractional division.
| |
|
Returns -1 if number is negative, 0 if number is 0, and 1 if number is greater than 0.
| |
|
Returns the square root of the given number.
| |
|
Returns the standard deviation of all the non-empty values in a given list of arguments. If an expression evaluates a range of cells all the non-empty values in the range are examined. The standard deviation is the square root of the variance.
| |
|
Adds (sums) the given expressions. If an expression evaluates to a range of cells all the values in the range are summed. Text cells in ranges are ignored. If an error condition is encountered in a range of cells, the sum function errors as well.
| |
|
Adds (sums) the values of cells that match a specified criteria.
| |
|
Returns the integer portion of the given number dropping any fractional portion.
| |
|
Computes the variance of all the non-empty values in a given list of arguments. If an expression evaluates a range of cells all the non-empty values in the range are examined. |