Using the Excel MIN Function


The Excel MIN function will return the smallest numeric value from a range of values. The function ignores TRUE/FALSE, text values, and empty cells.

To find the largest number from a range of values, use the MAX function.


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

Syntax Breakdown

Number 1
Required. The number for which you want to find the minimum value. The argument can be a number, name, array, or cell reference.

Logical values, such as TRUE and FALSE, and numbers entered as text are ignored, unless they are entered directly into the list of arguments.

Number 2
Number 2 and subsequent arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MIN returns the smallest value from a set of provided values. The function ignores empty cells, text values, and logical values. The function returns 0 (zero) if the arguments contains no numbers.

Arguments with error values or text that cannot be translated into a number will cause an error.

Use the MINA function if you would like to include logical values in a reference.