Excel Functions
On this page, you'll find the most commonly used functions, each demonstrated in a simple example.
Date and time functions
Logical functions
| IF | Perform actions if conditions are met |
| IFs | Nested IFs |
Lookup and reference functions
| CHOOSE | Show a value or perform an action based on a choice |
| HLOOKUP | Return a value from a table based on a value located anywhere in the first row |
| INDEX | Return a value based on column no. and row no. |
| INDEX + MATCH | Like HLOOKUP/VLOOKUP without being constrained to the first row/column |
| MATCH | Return the position of a value in a list |
| VLOOKUP | Return a value from a table based on a value located anywhere in the first column |
Math and trigonometry functions
| RAND | Randomly generate a value |
| ROUND | Round a value |
| ROUNDDOWN | Round a value down |
| ROUNDUP | Round a value up |
| SQRT | Take the square root |
| SUM | Calculate the sum of a series of values |
| SUMIF | Calculate the sum of the values that meet the condition |
Statistical functions
| AVERAGE | Take the average of a set of values |
| COUNT | Calculate the number of cells containing numbers |
| COUNTA | Calculate the number of non-empty cells |
| COUNTBLANK | Calculate the number of empty cells |
| COUNTIF | Calculate the number of cells that contain a specified value |
| MAX | Return the greatest value |
| MIN | Return the least value |
Text functions
| LEFT | Extract characters starting from the left |
| LOWER | Convert to lowercase |
| MID | Extract characters from a string |
| PROPER | Convert the first letter of each word to uppercase and the other letters to lowercase |
| RIGHT | Extract characters starting from the right |
| UPPER | Convert to uppercase |
Compatibility functions
| CONCATENATE | Join values, one after another |
| FORECAST | Extrapolate based on known data |
| RANK | Classify a value based on a series of values |