MIN Function in Excel, Google Sheets, Airtable & Notion
MIN returns the smallest number among its arguments. Blank cells and text in a range are ignored, and dates work too because they are numbers.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | MIN(number1, [number2], ...) |
| Google Sheets | ✔ Built in | MIN(value1, [value2, ...]) |
| Airtable | ✔ Built in | MIN(number1, [number2, ...])Compares fields of one record. For the smallest value across linked records, use a rollup with MIN(values). |
| Notion | ✔ Built in | min(number | list, ...)Also works on rollups and lists: min(prop("Prices")). |
| Excel | =MIN(A2:A6) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =MIN(A2:A6) | open sheets.new ↗ |
| Airtable | MIN(42, -7.5, 18, 0, 103) | |
| Notion | min([42, -7.5, 18, 0, 103]) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Value 42 -7.5 18 0 103
Arguments
| Argument | What it means |
|---|---|
number1 | The first number, cell or range. |
[number2], ... optional | More numbers or ranges. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=MIN(42, -7.5, 18, 0, 103) | -7.5 | Negative numbers are smaller than zero. | |
=MIN(A2:A10, 0) | At most 0 | Adding a constant caps the result, e.g. never above 0. | |
=MINIFS(B2:B10, A2:A10, "East") | Smallest East value | MINIFS (Excel 2019+, Sheets) applies conditions; it also skips zeros with "<>0" as a condition. | |
=MIN(C2:C10) | Earliest date | Dates are serial numbers, so MIN finds the earliest. |
Examples use Excel / Google Sheets syntax unless noted.
How MIN works
MIN scans its arguments and returns the lowest number. Inside a range it ignores empty cells, text and TRUE/FALSE, so a missing value is not treated as zero. If there are no numbers at all, MIN returns 0 rather than an error, which can look like a real result; check with COUNT if that matters.
A common need is “smallest value that is not zero”: use =MINIFS(A2:A10, A2:A10, "<>0"). For the second- or third-smallest value use SMALL. Because dates and times are stored as numbers, MIN also returns the earliest date in a range; format the result cell as a date.
Airtable's MIN compares fields of a single record, for example the lower of two quotes. Across records, use a rollup field with MIN(values). Notion's min() accepts numbers and lists, so it works directly on a rollup or a mapped relation.
Frequently Asked Questions
- Why does MIN return 0?
- Either a cell really contains 0, or there are no numbers in the range (for example numbers stored as text). Empty cells are ignored.
- How do I find the smallest value ignoring zeros?
- Use
=MINIFS(A2:A10, A2:A10, "<>0").