MIN

Get the smallest value.

MIN

Summary 

The Excel MIN function returns the smallest numeric value in a range of values. This function ignores empty cells, the logical values TRUE and FALSE, and text values.

Purpose 

Get the smallest value.

Return value 

The smallest value in the array.

Syntax 

=MIN (array)

Arguments 

  • array - The array from which you want to select the largest value.

Usage notes 

The MIN function is useful when you want to retrieve the smallest value from a set of data. For example, the fastest time in a race.

array can be an array constant or a range of cells.

0 votes. 0 / 5