Article updated on April 19, 2018

The MIN function allows you to retrieve the smallest number in a cell range.

The formula in cell D3 extracts the smallest number from cell range B3:B10, see picture above.

Excel Function Syntax

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


number1 - You need at least one argument. Required.

[number2] - Up to 254 arguments are possible. Optional.

Arguments can be constants, named ranges, cell references and arrays.

The MIN function ignores text and boolean values, however not errors.