Excel Formulas - Functions
Excel formulas and functions are the backbone of data analysis, reporting, and automation. On this page, you’ll find a well-organised list of Excel formulas and functions explained on ExlMentor. Each function is grouped by category and linked for quick access, helping you find the right formula for your task in seconds.
Mathematical & Statistical Functions
Math formulas help perform calculations in Excel such as addition, subtraction, multiplication, and division using mathematical operators like ” + − * / ” . Along with these basic operations, Excel also provides a wide range of advanced mathematical functions that are commonly used in accounting, finance, and data analysis.
| Functions | Description |
|---|---|
| SUM | Adds a range of numbers |
| AVERAGE | Calculates the average value |
| COUNT | Counts cells containing numbers |
| COUNTA | Counts non-empty cells |
| ROUND | Rounds numbers to a specified decimal |
| ROUNDUP | Rounds numbers up |
| ROUNDDOWN | Rounds numbers down |
| MIN | Returns the smallest value |
| MAX | Returns the largest value |
| ABS | Returns the absolute value |