Excel Cheatsheet
Explore a collection of the top 20 Excel formulas, including VLOOKUP, average, and concatenate.
SUM
The SUM formula adds up a range of numbers.
=SUM(range)
AVERAGE
The AVERAGE formula calculates the average of a range of numbers.
=AVERAGE(range)
MAX
The MAX formula returns the largest number in a range.
=MAX(range)
MIN
The MIN formula returns the smallest number in a range.
=MIN(range)
VLOOKUP
The VLOOKUP formula searches for a value in the first column of a table and returns a corresponding value from the specified column.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
HLOOKUP
The HLOOKUP formula searches for a value in the first row of a table and returns a corresponding value from the specified row.
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
INDEX
The INDEX formula returns the value of a cell in a specified row and column of a range.
=INDEX(array, row_num, col_num)
MATCH
The MATCH formula searches for a value in a range and returns its relative position.
=MATCH(lookup_value, lookup_array, [match_type])
IF
The IF formula performs a logical test and returns one value if the test is true and another value if the test is false.
=IF(logical_test, value_if_true, value_if_false)
COUNT
The COUNT formula counts the number of cells in a range that contain numbers.
=COUNT(range)
COUNTA
The COUNTA formula counts the number of non-empty cells in a range.
=COUNTA(range)
CONCATENATE
The CONCATENATE formula combines two or more text strings into one string.
=CONCATENATE(text1, text2, ...)
LEFT
The LEFT formula returns a specified number of characters from the beginning of a text string.
=LEFT(text, num_chars)
RIGHT
The RIGHT formula returns a specified number of characters from the end of a text string.
=RIGHT(text, num_chars)
LEN
The LEN formula returns the number of characters in a text string.
=LEN(text)
AND
The AND formula checks if all conditions are true and returns TRUE if they are, otherwise it returns FALSE.
=AND(condition1, condition2, ...)
OR
The OR formula checks if at least one condition is true and returns TRUE if it is, otherwise it returns FALSE.
=OR(condition1, condition2, ...)
NOT
The NOT formula reverses the value of a logical argument (TRUE becomes FALSE and vice versa).
=NOT(logical)
IFERROR
The IFERROR formula returns a custom result when a formula generates an error, and a standard result when no error is detected.
=IFERROR(value, value_if_error)
NOW
The NOW formula returns the current date and time.
=NOW()