Check out our new financial statement builder app
Protoolio Logo

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()
Recommended

Financial Statement Builder

A super simple and lightweight financial statement builder for income statements, balance sheets, cash flow statements, and forecasts.