## How to use the MIN function

*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*], ...)

### Arguments

*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.

### Articles with the 'MIN' Function

The following 5 articles have formulas that contain the MIN function.

Extract unique distinct values from a multi-column cell range

Question: I have cell values spanning over several columns and I want to create a unique list from that range. […]### Functions in 'Statistical'

The MIN function function is one of many functions in the 'Statistical' category.