Description
Use this function to find the smallest number in a set of values. Supported in Chains. Can be used with CHILDREFS.
MIN is useful for identifying the minimum value in a range of numbers.
Syntax
MIN(number_1, […, number_254)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number_1 |
Yes | The first number, cell reference, or range for which you want to find the minimum value. | A number, a reference to a cell containing a number, a cell range that contains numbers, or a formula which results in any of these. |
number_n
|
No | Additional numbers, cell references, or ranges to find the minimum value. | Additional numbers, references to cells containing numbers, cell ranges that contain numbers, or formulas which results in any of these. Up to 254 additional values can be provided. |
Example
Sample data
| A | B |
|---|---|
| 10 | 20 |
| 5 | 15 |
| 30 | 25 |
| 7 | 12 |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=MIN(A1:A4) |
Finds the smallest value in the range A1:A4. | 5 |
=MIN(A1:B4) |
Finds the smallest value in the range A1:B4. | 5 |
=MIN(A2, B2) |
Finds the smallest value between A2 and B2. | 5 |
=MIN(10, 20, 5, 15) |
Finds the smallest value among the numbers 10, 20, 5, and 15. | 5 |
Notes
- MIN ignores empty cells, logical values, and text in the supplied values.
- If the range contains no numbers, MIN returns 0.
Tips
- Use MIN with IF to find the minimum value based on a condition.
- Use conditional formatting to highlight the minimum value in a range.
Related functions
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
LARGE
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
SMALL
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA