Skip to content

Excel function · Statistics

Excel MIN function

MIN returns the smallest of the numbers you give it: the lowest quote, the lowest stock level, the earliest date. It is also used to put a ceiling on a calculation.

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

English Excel=MIN(number1, [number2], ...)
Turkish Excel=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

ArgumentRequiredDescription
number1RequiredThe first number, cell or range to search for the smallest value.
number2OptionalOptional 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.

D2fx=MIN(B2:B5)
Find the lowest quote and its supplier: example table
ABCDE
1SupplierQuoteLowestSupplier
2Brown & Sons48,250.0046,900.00Northgate Ltd
3Northgate Ltd46,900.00
4Harbour Trade51,300.00
5Star Market47,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.

C2fx=MIN(B2*0.05,2000)
Put a cap on a bonus: example table
ABC
1RepSalesBonus
2Emma28,0001,400
3Liam52,0002,000
4Olivia40,0002,000
5Noah61,5002,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".

D2fx=MIN(B2:B7)
Find the lowest stock and skip zeros: example table
ABCDE
1ProductStockMINExcluding Zeros
2Grounded socket250048
3Circuit breaker0
4Light switch48
5Cable duct120
6Lamp holder0
7Copper cable75
  • 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

Type this in Nexell

Add a row to the quote list showing the lowest price and the supplier who offered it

Convert to table

Bring 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.

Related functions

All statistics functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free