Page History
...
- Basic math functions ADD, SUBTRACT, MULTIPLY, and DIVIDE;
- More advanced math functions like SUM, PRODUCT, DIV, MOD, POWER, and LOG;
- Rounding functions ROUND, ROUNDDOWN, ROUNDUP, ROUND TO MULTIPLE, ROUNDSIG, ROUNDSIGUP, and ROUNDSIGDOWN;
- Comparison functions EQUAL, NOT EQUAL, LESS, LESS OR EQUAL, GREATER, and GREATER OR EQUAL;
- And the special function ANNUITY.
Overview
| Function | Description |
|---|---|
ADD (+) | Use the '+' (plus) sign to add values of some type of number. |
SUBTRACT (-) | Use the '-' (minus) sign to subtract values of some type of number. |
MULTIPLY (*) | Use the '*' (asterisk) sign to multiply values of some type of number. |
DIVIDE (/) | Use the '/' (forward slash) sign to divide values of some type of number. |
SUM | Adds the values of a collection of numbers. |
PRODUCT | Returns the product of the values of a collection of numbers. |
DIV | Returns the integer portion of a division. |
MOD | Returns the remainder of a division. |
POWER (**) | Use the '**' operator to raise a number to a power. |
LOG | Calculates the logarithm of a number to a base. |
ROUND | Rounds a number value to a specified number of decimal places. |
ROUND DOWN | Rounds a number value down to a specified number of decimal places. |
ROUND UP | Rounds a number value up to a specified number of decimal places. |
ROUND TO MULTIPLE | Rounds a number value to a specified multiple. |
ROUND UP TO MULTIPLE | Rounds a number value up to a specified multiple. |
ROUND DOWN TO MULTIPLE | Rounds a number value down to a specified multiple. |
ROUNDSIG | Alternative syntax for ROUND TO MULTIPLE. |
ROUNDSIGUP | Alternative syntax for ROUND UP TO MULTIPLE. |
ROUNDSIGDOWN | Alternative syntax for ROUND DOWN TO MULTIPLE. |
EQUAL (=) | The operator '=' compares two values and returns the boolean value TRUE if the left value is equal to the right value and FALSE otherwise. |
NOT EQUAL (!=) | The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to the right value and FALSE otherwise. |
LESS (<) | The operator '<' compares two values and returns the boolean value TRUE if the left value is smaller than the right value and FALSE otherwise. |
LESS OR EQUAL (<=) | The operator '<=' compares two values and returns the boolean value TRUE if the left value is smaller than or equal to the right value and FALSE otherwise. |
GREATER (>) | The operator '>' compares two values and returns the boolean value TRUE if the left value is greater than the right value and FALSE otherwise. |
GREATER OR EQUAL (>=) | The operator '>=' compares two values and returns the boolean value TRUE if the left value is greater than or equal to the right value and FALSE otherwise. |
ANNUITY | Computes an annuity. An annuity is a terminating "stream" of fixed payments. |
Functions
| Include Page | ||||
|---|---|---|---|---|
|
...
Overview
Content Tools