Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inMIN(number1, [number2], ...)
Google Sheets✔ Built inMIN(value1, [value2, ...])
Airtable✔ Built inMIN(number1, [number2, ...])
Compares fields of one record. For the smallest value across linked records, use a rollup with MIN(values).
Notion✔ Built inmin(number | list, ...)
Also works on rollups and lists: min(prop("Prices")).
Try MIN with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
-7.5
Your formula, ready to paste
Excel=MIN(A2:A6) open excel.new ↗
Google Sheets=MIN(A2:A6) open sheets.new ↗
AirtableMIN(42, -7.5, 18, 0, 103)
Notionmin([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

ArgumentWhat it means
number1The first number, cell or range.
[number2], ... optionalMore numbers or ranges.

Examples

FormulaResultWhyCopy
=MIN(42, -7.5, 18, 0, 103)-7.5Negative numbers are smaller than zero.
=MIN(A2:A10, 0)At most 0Adding a constant caps the result, e.g. never above 0.
=MINIFS(B2:B10, A2:A10, "East")Smallest East valueMINIFS (Excel 2019+, Sheets) applies conditions; it also skips zeros with "<>0" as a condition.
=MIN(C2:C10)Earliest dateDates 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").

Part of the Statistics & Counting functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.