Syntax
=MIN(value1, [value2, ...])
value1- A number, cell or range.
value2, ...- Optional. More values or ranges.
MIN function in Google Sheets
MIN returns the smallest number in a set of values. It's the quickest way to find the lowest price, earliest score or worst result in a list.
Practice MIN
Task 1 of 2
Find the coldest overnight low of the week 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.
MIN examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Revenue |
| 2 | Ava | West | Monitor | 12 | $2,400.00 |
| 3 | Liam | East | Keyboard | 30 | $1,500.00 |
| 4 | Maya | West | Mouse | 45 | $900.00 |
| 5 | Noah | North | Monitor | 8 | $1,600.00 |
| 6 | Zara | East | Monitor | 15 | $3,000.00 |
| 7 | Omar | West | Keyboard | 22 | $1,100.00 |
| Formula | Result | What it shows |
|---|---|---|
=MIN(E2:E7) | $900.00 | Lowest revenue of any rep. |
=MIN(D2:D7) | 8 | Fewest units sold. |
=MIN(E2:E7, 1000) | 900 | Mixing a range and a fixed number: never more than 1000. |
Tips and common mistakes
- Text and blank cells are ignored. If there are no numbers, MIN returns 0.
- To find the second- or third-smallest value, use SMALL.
- To return the rep's name next to the minimum, combine with INDEX and MATCH: =INDEX(A2:A7, MATCH(MIN(E2:E7), E2:E7, 0)).
Related functions
Learning step by step? MIN is covered in Lesson 4: MIN & MAX of the free course.