Excel Functions

On this page, you'll find the most commonly used functions, each demonstrated in a simple example.

Date and time functions :

 TODAY Show today's date

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 FORECAST Extrapolate based on known data MAX Return the greatest value MIN Return the least value RANK Classify a value based on a series of values

Text functions :

 CONCATENATE Join values, one after another 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