MIN Function


MIN function in Excel is used to find the ‘Smallest Number or Date’ from a set of values. MIN function ignores empty cells, the logical values and text values.

Function Type



Get the smallest value in a set of values

Return value

Number equivalent to the Smallest Number or Date


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


number1 – can be a direct value, cell reference or range reference.

number2 – [optional] can be a direct value, cell reference or range reference

Example 1

Example 2


The MIN function can handle up to 255 arguments.

The MIN function ignores empty cells.

The MIN function ignores TRUE and FALSE values, and numbers entered as text. To consider logical values, MINA function should be used.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel