# MIN

Formulas / MIN
Find the smallest value in the data supplied.
`MIN(number1, number2, ...)`
• number1 - required argument
• number2 - [OPTIONAL] additional argument
• â€¦ - [OPTIONAL] additional arguments

## Examples

• `=MIN(12,17,25,11,23)`

The MIN function returns the smallest value from a given set of numbers. For example, this returns 11.

• `=MIN(A1:A10)`

The MIN function can also be used with a range of cells. For example, this returns the minimum value in the range A1:A10.

• `=MIN(5,10)`

The MIN function can also be used to compare two numbers. For example, this returns 5.

• `=MIN(A1,A2,A3)`

The MIN function can also be used to compare multiple cells. For example, the formula returns the smallest value in A1:A3.

• `=MIN(A1:A10,1)`

The MIN function can also be used to compare a range of cells and a single number. For example, the formula returns the minimum value in the range A1:10.

• `=MIN(A1:A10,C1:C10)`

The MIN function can also be used to compare two ranges of cells. For example, the formula returns the minimum value in C1:C10 and A1:A10.

## Summary

The MIN function returns the smallest value in a set of numerical, name, array, or reference arguments. It is optional to include the first argument, number1, and additional subsequent arguments.

• The MIN function returns the smallest value in the data set, ignoring empty cells, text values, logical values (TRUE and FALSE), and numbers entered as text on the worksheet.
• The MIN function can accept hardcoded constants, cell references, or ranges in any combination.
• The MIN function ignores null cells.