Spotting MAX and MIN Values
Find the largest and smallest numbers in a range with MAX and MIN.
The Biggest and the Smallest
Once you've counted your data, a natural next question is: what's the highest value, and what's the lowest?
What was the best sales day? What's the cheapest item? The lowest test score?
Two simple functions handle this: MAX finds the largest number in a range, and MIN finds the smallest. Let's explore both.
Meet the MAX Function
MAX returns the largest number in a range.
Its shape matches the functions you already know:
- =MAX(range)
If A1:A5 holds 120, 95, 200, 150, 80, then =MAX(A1:A5) returns 200, the highest value present.
=MAX(A1:A5)All lessons in this course
- Counting Numbers With COUNT
- Counting Anything With COUNTA
- Finding Empty Cells With COUNTBLANK
- Spotting MAX and MIN Values