# MIN function in Excel

> MIN returns the smallest number from a list of values or ranges.

Source: https://spreadsheetpractice.com/functions/min · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** MIN returns the smallest number from a list of values or ranges.
- **Syntax:** `=MIN(number1, [number2], ...)`
- **Most common use:** `=MIN(B2:B5)` returns $1,180 (Lowest quote; Corvid's missing quote is ignored)
- **Available in:** Every current version
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The smallest number, or 0 if the ranges contain no numbers.
- **Google Sheets:** Also available in Google Sheets.

## What it does

MIN returns the smallest number from a list of values or ranges. It's the quick way to find the lowest quote, the earliest date or the shortest time, and paired with a fixed number it also works as a cap that keeps a result from going above a limit.

## Syntax

`=MIN(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range to check. |
| `number2` | Optional | More numbers, cells or ranges, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=MIN(B2:B5)` | $1,180 | Lowest quote; Corvid's missing quote is ignored |
| F3 | `=MIN(C2:C5)` | 7 | Shortest lead time in days |
| F4 | `=MIN(B5,1200)` | $1,200 | Caps Dunmore's quote at a $1,200 budget by taking the smaller value |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Supplier | Quote | Lead days |  | Check | Result |
| 2 | Acme | $1,250 | 14 |  | Lowest quote | $1,180 |
| 3 | Brightline | $1,180 | 21 |  | Shortest lead time | 7 |
| 4 | Corvid |  | 10 |  | Dunmore capped | $1,200 |
| 5 | Dunmore | $1,320 | 7 |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| MIN returns 0 | Either the range really contains a 0, or there are no numbers at all, for example because they are stored as text. |
| A blank cell isn't treated as zero | MIN skips empty cells in a range, which is usually right. If a blank should count as 0, enter the 0. |
| The wrong date comes back | Dates stored as text aren't numbers, so MIN skips them. Check that the dates are right-aligned. |

## Tips

- To find the smallest value that meets a condition, use MINIFS rather than a filter.
- MIN(value, limit) caps a value; MAX(value, floor) sets a floor. Together they clamp a number into a range.

## Related functions

- [MAX](https://spreadsheetpractice.com/functions/max): MAX returns the largest number from a list of values or ranges: the top sale, the latest date, the highest temperature.
- [MINIFS](https://spreadsheetpractice.com/functions/minifs): MINIFS returns the smallest value among the rows that meet one or more conditions: the cheapest quote for a part, the earliest due date in a project, the lowest score above zero.
- [SMALL](https://spreadsheetpractice.com/functions/small): SMALL returns the k-th smallest value in a range: k = 1 is the smallest, 2 the second smallest, and so on.

## Questions

### How do I find the minimum but ignore zeros?

Use =MINIFS(B2:B5,B2:B5,">0") in Excel 2019 or later.

### Can MIN find the earliest date?

Yes. Dates are stored as numbers, so MIN returns the earliest one. Format the result as a date.

## Practice

A graded MIN exercise ("Average, best and worst") is on [the MIN page](https://spreadsheetpractice.com/functions/min). It is checked instantly, then re-checked on changed data.

Lessons that use MIN:

- [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
