The MIN function
Returns the smallest number. Text and blank cells in a range are ignored.
Syntax
MIN(number1, [number2], ...)- number1
- The first number, cell or range.
- number2 (optional)
- More numbers or ranges.
Examples
E1=MIN(C2:C6)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | 180 | |
| 2 | North | Shoes | 500 | ||
| 3 | South | Shoes | 300 | ||
| 4 | North | Bags | 250 | ||
| 5 | North | Shoes | 420 | ||
| 6 | South | Bags | 180 |
B1=MIN(5,-2,8)
| A | B | |
|---|---|---|
| 1 | -2 |