MIN returns the least number among its arguments. Like MAX it ignores text and blanks in a range and returns 0 when no numbers are present. Use it for the lowest score or cheapest price; MIN(cap, value) clamps a result at an upper bound.
Returns a number. Text and blanks in ranges are ignored; no numbers gives 0.
Smallest value plus a constant clamp, measured live. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =MIN(A2:A6) | 45 | Bottom score |
| =MIN(B2:B6) | 800 | Cheapest sale |
| =MIN(A2:A8) | 45 | Blank and text ignored |
| =MIN(10,20,30) | 10 | Direct numbers |
| =MIN(A2:A4) | 78 | First three scores |
| =MIN(0,A2:A6) | 0 | Clamp at 0 |
| =MIN(-5,-10) | -10 | Smaller negative |
| =MIN(B2:B8) | 600 | All sales |
Edit the table or type any formula β the engine evaluates instantly. Load a preset to find lows and clamp values.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User β each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
MIN is a core statistical function present in every Excel version and platform.
| Platform | Support | Notes | Gotcha |
|---|
MIN is one piece. The full course walks the toolkit end to end with live, measured examples.