Lesson 4 · Basics
MIN & MAX
Practice MIN and MAX in Google Sheets: find the highest and lowest values and the spread between them.
What is the most expensive listing? Answer in D2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Highest and lowest with MAX and MIN
=MAX(value1, [value2, ...])
=MIN(value1, [value2, ...])
MAX returns the biggest number in a range and MIN the smallest. Like SUM, both ignore text and blanks.
You can use them inside bigger formulas. The range (spread) of a data set is simply =MAX(B2:B9)-MIN(B2:B9).
Tip: Need the second-highest value rather than the highest? See LARGE & SMALL.