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 |