MIN Function in Excel

MIN ignores text, empty cells, and logical values inside a range. MINA treats text as 0, FALSE as 0, and TRUE as 1 — so it can silently return 0 when your data contains any text at all.

Rule: use MIN unless you have a specific reason to want text-as-zero behavior (which is almost never). Every "why is my minimum zero?" bug traces back to accidentally picking MINA from Excel's auto-suggest.

Excel's MIN treats an empty range as if it had one value: 0. It doesn't return an error. This is a design decision that predates modern Excel and won't change.

Guard with COUNT: =IF(COUNT(range)=0, "no data", MIN(range)). Or use IFERROR only after making the empty case genuinely error out — e.g. =IFERROR(MIN(range)/COUNT(range)*COUNT(range), "no data") (ugly but works).

Yes. Excel stores dates as serial numbers, so MIN naturally returns the earliest date. Format the result cell as a date to display it properly.

Trap: if your dates are stored as text (common with imported CSVs), MIN will either error or return the wrong result. Convert with DATEVALUE() first, or fix the source column's format.

Use MINIFS (Excel 2019+): =MINIFS(value_range, criteria_range, criterion). For example, =MINIFS(B2:B100, C2:C100, "North") returns the smallest value from B where C is "North".

For Excel 2016 and earlier, use an array formula: =MIN(IF(C2:C100="North", B2:B100)) entered with Ctrl+Shift+Enter.

MIN returns the smallest value. SMALL returns the k-th smallest — you specify the position. =SMALL(range, 1) equals =MIN(range), but =SMALL(range, 2) returns the second-smallest, which MIN can't do.

Use SMALL for trimmed-mean calculations, "second best" logic, or when you want to skip the outlier and get the runner-up.

Yes — zero is a number and MIN counts it. If your range contains zeros and other positive values, MIN returns 0.

To find the smallest non-zero value, use an array formula: =MIN(IF(range<>0, range)) entered with Ctrl+Shift+Enter (or plain Enter in Excel 365).

Yes. MIN returns the mathematically smallest value, which means large negative numbers "win." For example, =MIN(-50, -10, 20) returns -50, not -10 or 20.

If you want the smallest by absolute value, use =MIN(ABS(range)) — but that's a different question ("closest to zero") and requires an array formula in older Excel.

Pass the floor as an extra argument: =MIN(A2, 500) returns A2 or 500, whichever is smaller. This is how you say "give me the value, but never more than 500" — a cap.

To enforce a minimum-floor instead (never less than X), use MAX: =MAX(A2, 0) ensures the result is never negative.

MIN propagates errors — any error in the range returns that error. Fix at the source with IFERROR, or wrap the range: =MIN(IFERROR(range, "")) as an array formula.

Better: use AGGREGATE, which has built-in error handling: =AGGREGATE(5, 6, range) — the "5" means MIN, the "6" means ignore errors. Works in Excel 2010+.

Yes. A common pattern: highlight the smallest value in a range with formula =A2=MIN($A$2:$A$100). Only the cell(s) matching the minimum get highlighted.

Watch the mixed references: A2 is relative (changes per row), $A$2:$A$100 is absolute (the range stays the same as Excel evaluates each cell).

Yes, using a 3D reference: =MIN(Sheet1:Sheet4!A1) returns the smallest value of cell A1 across four sheets. You can also do =MIN(Sheet1!A2:A10, Sheet2!A2:A10).

Requires the sheets to be adjacent (Sheet1 through Sheet4 must be next to each other in the tab order) for the 3D syntax to work.

For small datasets (up to ~10,000 cells) the difference is imperceptible. For larger datasets, MINIFS is slightly slower because it evaluates a criterion per row.

Both are fast compared to array-formula alternatives. If your workbook has hundreds of MINIFS calls across huge ranges, consider a Power Query pre-aggregation instead.