Mastering the MIN Formula in Excel
Learn how =MIN() finds the lowest numerical value in any dataset, how to rank 2nd and 3rd lowest values with SMALL(), and how to avoid the MINA text-to-zero trap.
📉 What is the MIN Formula?
The MIN formula returns the smallest numerical value in a range or set of numbers. It is used constantly by analysts to answer questions like:
- What was our lowest product price across all suppliers?
- What was the fastest customer support response time?
- What was the minimum daily temperature recorded?
B2:B10.⚖️ MIN vs SMALL() vs MINA
=MIN()
Ignores text & blank cells. Finds the absolute lowest number in the range.
=SMALL()
Finds the k-th smallest value. Passing 2 returns 2nd lowest, 3 returns 3rd lowest!
=MINA()
Evaluates text and FALSE as 0! If your range contains any text, =MINA returns 0 unexpectedly!
=MINA() on ranges containing labels or comments like "Out of Stock" — Excel treats the text as 0, making your minimum 0 instead of the real lowest price! Use standard =MIN().🎮 Interactive MIN & SMALL Simulator — Live Spreadsheet
Change any vendor quote price or select different formulas to see live cell highlighting & step-by-step ranking breakdown!
=MIN(B2:B6)⚠️ Key Analyst Rules for MIN
Negative Numbers (-50 is SMALLER than -10)
Remember that for negative numbers, -50 is smaller than -10. In a profit/loss column, =MIN() finds your largest loss!
Zero vs Blank in MIN
Blank cells are ignored by =MIN(). However, 0 is a valid number, so if a cell contains 0, =MIN() will return 0.
Status Bar Quick Check
Right-click the Excel Status Bar (bottom right) and check Minimum. Now whenever you select any range, Excel displays the lowest value live!
Test Your MIN Mastery
10 interview-level questions on MIN, SMALL(array, k), negative values, and MINA pitfalls