Minimum value

Minimum value

Generic formula 

=MIN(range)

Related formulas 

Minimum value if

Maximum value

Maximum value if

Minimum if multiple criteria

Maximum if multiple criteria

Explanation

To get the minimum value from a set of numbers, use the MIN function.

In the example shown, the formula in cell I6 is:

=MIN(C6:G6)

The MIN function is fully automatic. It accepts one or more arguments, which can be numbers or cell references that point to numbers, then returns the minimum value.

Minimum value

Generic formula 

=MIN(range)

Related formulas 

Minimum value if

Maximum value

Maximum value if

Minimum if multiple criteria

Maximum if multiple criteria

Explanation

To get the minimum value from a set of numbers, use the MIN function.

In the example shown, the formula in cell I6 is:

=MIN(C6:G6)

The MIN function is fully automatic. It accepts one or more arguments, which can be numbers or cell references that point to numbers, then returns the minimum value.