Google Sheets function
MIN function in Google Sheets
MIN in Google Sheets returns the smallest numeric value from the cells, ranges, or numbers you provide. Cells without numbers inside referenced ranges are ignored. Use MIN to find the lowest price, earliest numeric measurement, smallest score, or any other lower bound in a numeric dataset.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=MIN(value1, [value2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
value1 | Yes | The first value or range to check for the minimum. |
value2, ... | No | Additional values or ranges to check. |
Examples
Find the lowest quote
| A | B | |
|---|---|---|
| 1 | Vendor | Quote |
| 2 | North | 420 |
| 3 | East | 385 |
| 4 | West | 410 |
=MIN(B2:B4)Result: 385
385 is the smallest numeric value in the quote range.
Common mistakes
Passing typed text directly as an argument.
Use cells, numbers, or ranges containing numbers. Direct text arguments can return #VALUE!.
Looking for the smallest label instead of the smallest number.
MIN works on numeric values. Pair it with a lookup when you also need the matching label.