0 of 62
Basics·Lesson 11 of 62Free

How to use MAX in Google Sheets

Find the biggest value

How MAX works

MAX returns the largest number in a range. MIN returns the smallest.

MAX(range)
Example on this data
=MIN(F2:F11)→30

MIN works the same way: the cheapest price.

What you’ll do

This time you’ll find the biggest single order by units. Picking out the largest or smallest value is how you spot a record month, a top customer or an outlier worth checking.

Build it, step by step

  1. 1
    Start the formula

    Click K2 and type =MIN( Every formula starts with =, then the function’s name and an open bracket.

  2. 2
    Pick the cells
  3. 3
    Close it and press Enter

Your formula goes in K2.

K2
ABCDEFGHIJK
1OrderRepRegionProductUnitsPriceOrder dateShip date
21001AnaWestDesk32401/5/20261/9/2026
31002BoEastChair8851/12/20261/20/2026
41003CyWestLamp12301/19/20261/22/2026
51004DiNorthDesk22402/2/20262/13/2026
61005AnaWestChair5852/9/20262/12/2026
71006EveSouthShelf41202/16/20262/27/2026
81007BoEastLamp20303/2/20263/4/2026
91008CyWestShelf11203/9/20263/18/2026
101009DiNorthChair6853/16/20263/19/2026
111010EveSouthDesk72403/23/20264/1/2026
Ctrl+/ shows the shortcuts

The first 18 lessons are free. Pro unlocks the other 44, including a real-world scenario for every section and five closing projects.

See Pro, $49.99 once