MIN Function

About

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

Statistical

Purpose

Get the smallest value in a set of values

Return value

Number equivalent to the Smallest Number or Date

Syntax

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

Arguments

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


Notes

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