| 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 | | | |
| 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 |
| 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 |
| MROUND | The MROUND function rounds a number to the nearest multiple of a specified value. | | | |
| NORMDIST | Calculates Normal distribution for a measure, mean, and standard deviation | | | |
| NORMSDIST | Calculates the standard normal distribution for a measure, with a mean of 0 and a standard distribution of 1 | | | |
| NORMINV | Calculates the inverse normal distribution for a measure, mean, and standard deviation. | | | |
| NORMSINV | Calculates the inverse standard normal distribution for a measure, with a mean of 0, and standard deviation of 1. | | | |
| ODD | Rounds to the nearest higher odd number | | | |
| 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 | The ROUNDDOWN function always rounds a number down, toward zero | | | |
| ROUNDUP | The ROUNDUP function always rounds a number up, away from zero | | | |
| SQRT | Returns the square root of a number | SQRT(value) | SQRT(COLUMN1) | Returns the exponential of COLUMN1 |
| SUM | Returns the sum of all the numbers in the argument | Sum(value1,[value2]....) | SUM(COLUMN1, COLUMN2) | Returns the sum of COLUMN1 and COLUMN2 |
| PCT | Used for a percentage calculation | PCT(value:number) | SALES + PCT(10) = SALES + 10% | Returns percentage value |