What it does
MIN follows the same rules as MAX: it skips empty cells, text and TRUE/FALSE values but counts 0. On a date column it returns the earliest date. To find who owns the smallest value, combine it with INDEX and MATCH.
MIN is the way to put a ceiling on a calculation: =MIN(B2*0.05,2000) caps a 5% bonus at 2,000. For a floor use MAX, and for both, =MAX(0,MIN(…,2000)).
If zeros in your list mean "no data", MIN returns them as the smallest value. To avoid that, use =MINIFS(B2:B20,B2:B20,">0"). For the second smallest value use SMALL; for the smallest that meets a condition, MINIFS.
Syntax
=MIN(number1, [number2], ...)=MİN(sayı1; [sayı2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
number1 | Required | The first number, cell or range to search for the smallest value. |
number2 | Optional | Optional further numbers or ranges, up to 255 arguments. |
Examples
1Find the lowest quote and its supplier
D2 finds the lowest quote; E2 uses MATCH to find its row and INDEX to return the supplier's name.
=MIN(B2:B5)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Supplier | Quote | Lowest | Supplier | |
| 2 | Brown & Sons | 48,250.00 | 46,900.00 | Northgate Ltd | |
| 3 | Northgate Ltd | 46,900.00 | |||
| 4 | Harbour Trade | 51,300.00 | |||
| 5 | Star Market | 47,450.50 |
- D2
=MIN(B2:B5) - E2
=INDEX(A2:A5,MATCH(D2,B2:B5,0))
The lowest quote is 46,900.00, from Northgate Ltd.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Put a cap on a bonus
The bonus is 5% of sales, but no more than 2,000. MIN picks the smaller of the two values, so bonuses above the cap stay at 2,000.
=MIN(B2*0.05,2000)| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Bonus |
| 2 | Emma | 28,000 | 1,400 |
| 3 | Liam | 52,000 | 2,000 |
| 4 | Olivia | 40,000 | 2,000 |
| 5 | Noah | 61,500 | 2,000 |
- C2 (filled down to C5)
=MIN(B2*0.05,2000)
Emma's bonus is 1,400; Liam and Noah, whose 5% would exceed the cap, get 2,000. Olivia's bonus lands exactly on the cap: 2,000.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3Find the lowest stock and skip zeros
Products not yet counted were entered as 0. MIN returns that zero; MINIFS filters the range by itself with the condition ">0".
=MIN(B2:B7)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Stock | MIN | Excluding Zeros | |
| 2 | Grounded socket | 250 | 0 | 48 | |
| 3 | Circuit breaker | 0 | |||
| 4 | Light switch | 48 | |||
| 5 | Cable duct | 120 | |||
| 6 | Lamp holder | 0 | |||
| 7 | Copper cable | 75 |
- D2
=MIN(B2:B7) - E2
=MINIFS(B2:B7,B2:B7,">0")
MIN returns 0; with zeros skipped the lowest stock is 48 units, the light switch.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Result is 0
Cause: There are no numbers in the range, or some cells contain 0. MIN also returns 0 for an empty range.
Fix: To skip zeros use MINIFS; check with COUNT whether the range holds numbers at all.
- #N/A
Cause: One of the cells in the range holds an error.
Fix: Fix the error, or use
=AGGREGATE(5,6,B2:B20), which skips errors.
Good to know
- To keep a value between a lower and an upper limit, nest the two functions:
=MAX(0,MIN(B2,100))keeps the result between 0 and 100. - To find the earliest date, use
=MIN(A2:A100)on the date column and give the result a date format.
In Nexell
Get Nexell to do it from a sentence
Add a row to the quote list showing the lowest price and the supplier who offered it
Convert to tableBring your quote list into the tool and type this. Nexell finds the lowest price and the supplier who offered it and shows the result in a preview first; nothing changes until you approve.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I find the smallest value excluding zeros?
Use =MINIFS(B2:B20,B2:B20,">0"); because the range itself is the condition, zeros are skipped. MINIFS is available in Excel 2019 and Microsoft 365.
How do I find which supplier gave the lowest quote?
Use =INDEX(A2:A10,MATCH(MIN(B2:B10),B2:B10,0)): MATCH finds the row of the smallest value and INDEX returns the supplier on that row.