MIN and MAX
Find the smallest and largest numbers in a range
0 of 3 done · Lesson 11 of 18
Understand
Your finance manager wants the fastest and slowest payment times in the invoice list. MIN finds the low end of a numeric range. MAX finds the high end.
=MIN(where to find the smallest number)
=MAX(where to find the largest number)
A worked example
=MIN(D2:D9)
where to find the smallest number
This returns 9
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Invoice | Client | Region | Days to pay |
| 2 | 501 | Kea Ltd | Waikato | 18 |
| 3 | 502 | Rimu Co | Otago | 42 |
| 4 | 503 | Northwind | Auckland | 11 |
| 5 | 504 | Halcyon | Nelson | 27 |
| 6 | 505 | Tuatara | Waikato | 64 |
| 7 | 506 | Fernway | Otago | 9 |
| 8 | 507 | Pounamu | Auckland | 35 |
| 9 | 508 | Brightsmith | Nelson | 23 |