Statistical
Modern
MIN
Returns the smallest number in a range.
Available in All versions
Syntax
MIN(number1, [number2])What it returns
The minimum value.
Arguments
| Argument | Required | Description |
|---|---|---|
number1 |
Yes | The first number or range. |
number2 |
No | Additional numbers or ranges (up to 255). |
Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 10 |
| 3 | 20 |
| 4 | 30 |
| 5 | 40 |
Result
10
MIN returns the smallest number in the range (10).
=MIN(B2:B100)Important to know
Ignores text and empty cells.
If the referenced range contains no numbers, returns 0.