- ABS - returns the absolute value of a number
- AND - logical AND (all conditions must be fulfilled)
- AVERAGE - returns the average of its arguments
- AVERAGEA - returns the average of its arguments, including numbers, text, and logical values
- CEILING - rounds a number to the nearest integer or to the nearest multiple of significance
- CONCATENATE - joins several text items into one text item
- COUNT - counts how many numbers are in the list of arguments
- COUNTBLANK - counts the number of empty cells in a range of cells
- LEFT - returns the leftmost characters from a text value
- MAX - returns the maximum value in a list of arguments
- MIN - returns the minimum value in a list of arguments
- RIGHT - returns the rightmost characters from a text value
- ROUND - rounds a number to a specified number of digits
- ROUNDDOWN - rounds a number down, toward zero
- ROUNDUP - rounds a number up, away from zero
- STDEV - estimates standard deviation based on a sample
- SUM - adds its arguments
- VAR - estimates variance based on a sample
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article