Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)