How to Use MIN/MAX in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: MAX returns the largest value and MIN returns the smallest. The formulas are =MAX(value1, [value2, ...]) and =MIN(value1, [value2, ...]).

What MIN and MAX do

MAX finds the highest number in the cells you give it, and MIN finds the lowest. They are the quickest way to find the best sale, the lowest price or the earliest and latest values in a column.

Syntax

=MAX(value1, [value2, ...])
=MIN(value1, [value2, ...])

Google's help pages for MAX and MIN say each argument must be a cell, a number or a range of numbers. Cells without numbers are ignored. Entering text values directly causes a #VALUE! error. To include text, use MAXA or MINA.

A step-by-step example

Here are five test scores in cells A1:B6.

AB
1NameScore
2Ann82
3Ben64
4Cara91
5Dev77
6Eli58

To find the highest score:

=MAX(B2:B6)

This returns 91. =MIN(B2:B6) returns 58.

Combine them to get a spread

Subtract one from the other to see the gap between the best and worst score:

=MAX(B2:B6) - MIN(B2:B6)

This returns 33 (91 minus 58).

Common mistakes

Try it yourself

Use the score table above (A1:B6). Type your formula into the box, starting with =, then press Check.

Exercise 1: Highest score

Write a formula that returns the highest score in B2:B6.

Hint: one range argument.

Exercise 2: The spread

Write a formula that returns the difference between the highest and lowest scores in B2:B6.

Hint: subtract MIN from MAX.

What to learn next

Syntax and rules in this guide were checked against Google's MIN/MAX help page. See all guides.