Find the Highest Value with MAX

Instantly pull the largest number out of any list.

You will learn to

• Use MAX to return the largest value in a range

How it works

MAX returns the largest number in a set of values. =MAX(B2:B6) checks every number in B2 through B6 and returns the biggest. Text and empty cells are ignored.

=MAX(B2:B6)