| ABS | Returns the absolute value of a number, a number without its sign | ABS(value) | ABS(COLUMN1) | Returns the absolute value of COLUMN1 |
| AVERAGE | Returns the average of the arguments | Average(value1,[value2]....) | AVERAGE(COLUMN1, COLUMN2) | Returns the average of COLUMN1, COLUMN1 |
| AVERAGEIF | Returns the average of the filtered values that satisfy the given condition | AVERAGEIF([Range], condition) | AVERAGEIF([Quantity],[Units Sold], “>10000”) | Returns the average of Quantity and Units Sold if they are above 10000 |
| AVERAGEEXNEG | Returns the average of the arguments excluding negatives | AverageExNeg(value1,[value2]....) | | |
| AVERAGEEXZERO | Returns the average of the arguments excluding zeros | AverageExZero(value1,[value2]....) | | |
| AVERAGEEXZERONEG | Returns the average of the arguments excluding zeros and negatives | AverageExZeroNeg(value1,[value2]....) | | |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance | CEILING(value, significance) | CEILING(COLUMN1) | Returns the ceiling of COLUMN1 to the significance of two decimal |
| COUNT | Counts the number of items in the list | COUNT (value1,value2....) | COUNT(Column1,Column2,Column3) | Returns the count of the number of items in a range |
| COUNTIF | Returns the count of items that match the specified condition | Count(list, condition) | COUNTIF([100,500,120],"<200") COUNTIF([[Quantity],[Units Sold]],BLANK) | Returns 2, since only two value in the given list matches the condition Returns 1,2 or 0 depending on how many blank values are in Quantity, Units Sold in each row. This value can be used to set conditional formatting or used with IF condition to fill value in another column |
| DIVIDE | Returns the division of two values | DIVIDE(Numerator, Denominator, Alternate) | DIVIDE(COLUMN1, COLUMN2, 0) | Returns COLUMN1/COLUMN2 and if any error, returns 0 |
| EVEN | Rounds to the nearest higher even number | | | |
| EXP | Returns e raised to the power of a given number | EXP(value) | EXP(COLUMN1) | Returns the exponential of COLUMN1 |
| FLOOR | Rounds a number (towards zero) to the nearest specified multiple of significance | FLOOR(value, significance) | FLOOR(COLUMN1) | Returns the floor of COLUMN1 to the significance of two decimal |
| INDEXOF | Returns the index of the first occurrence of a number in an array of numbers | | | |
| LARGE | Returns the nth largest number from a list of values | | | |
| LOG | Returns the logarithm of a number to the base specified | LOG(value,base) | LOG(COLUMN1, 10) | Returns the Log to the base 10 of COLUMN1 |
| ODD | Rounds off an input number and returns the nearest higher odd number. | | | |
| MAX | Returns the largest number in a set of values | Max(value1,[value2]....) | MAX(COLUMN1,COLUMN2,COLUMN3) | Returns the maximum of COLUMN1, COLUMN2, COLUMN3 |
| MIN | Returns the smallest number in a set of values | Min(value1,[value2]....) | MIN(COLUMN1,COLUMN2,COLUMN3) | Returns the minimum of COLUMN1, COLUMN2, COLUMN3 |
| MOD | Divides two numbers and returns the remainder | | | |
| MROUND | Rounds a number to the nearest multiple of a specified value. | | | |
| NUMBERVALUE | Converts text to a number | | | |
| ODD | Rounds to the nearest higher odd number | | | |
| PCT | Used for a percentage calculation | | | |
| POWER | Returns the result of a number raised to a power | POW(value,power) | POW(COLUMN1, 2) | Returns the COLUMN1 to the power of 2 |
| RAND | Returns a random number between 0 and 1 | RAND() | RAND(0,1) | Returns a random number like 0.1,0.2,.. |
| RANDBETWEEN | Returns a random number between two values | RANDBETWEEN(value1,value2) | RANDBETWEEN(0,100) | Returns a random number between 0 and 100 |
| ROUND | Rounds a number to the specified number of decimal places | ROUND(value, significance) | ROUND(COLUMN1, 2) | Returns the round of COLUMN1 to the significance of two decimal |
| ROUNDDOWN | Rounds a number down, toward zero | | | |
| ROUNDUP | Rounds a number up, away from zero | | | |
| SMALL | Returns the nth smallest number from a list of values | | | |
| SORT | Accepts a series of values and returns an array of the values sorted in ascending order. | | | |
| SUBTRACT | Accepts a series of values, subtracts them, and returns a number. | | | |
| SUM | Returns the sum of all the numbers in the argument | Sum(value1,[value2]....) | SUM(COLUMN1, COLUMN2) | Returns the sum of COLUMN1 and COLUMN2 |
| SQRT | Returns the square root of a number | | | |