MIN

Excel Functions

Get the smallest value.

Syntax

EXCEL

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

Arguments

Parameter	Description
`number1`	Number, reference to numeric value, or range that contains numeric values.
`number2`	[optional] Number, reference to numeric value, or range that contains numeric values.

Return Value

The smallest value in supplied data

Details

The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data. For example, MIN can return the fastest time in a race, the earliest date, the smallest percentage, the lowest temperature, or the bottom sales number. The MIN function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MIN ignores empty cells, text values, and the logical values TRUE and FALSE. The MIN function returns the smallest numeric value in supplied data: When given a range, MIN returns the smallest value in the range: The MIN function can accept a mix of arguments:

Examples

Basic example

The MIN function returns the smallest numeric value in supplied data:

EXCEL

=MIN(12,17,25,11,23) // returns 11

Basic example

When given a range, MIN returns the smallest value in the range:

EXCEL

=MIN(A1:A10) // minimum value in A1:A10

Mixed arguments

The MIN function can accept a mix of arguments:

EXCEL

=MIN(5,10)
=MIN(A1,A2,A3)
=MIN(A1:A10,1)
=MIN(A1:A10,C1:C10)

Logical values

The MIN function will ignore logical values and numbers entered as text that appear on the worksheet. However, if such values are provided directly as

EXCEL

=MIN(5,TRUE) // returns 1
=MIN(7,5,"3") // returns 3

MIN

Syntax

Arguments

Return Value

Details

Examples

See Also