Maximum value

Maximum value

Generic formula 

=MAX(range)

Related formulas 

Maximum value if

Minimum value

Minimum value if

Minimum if multiple criteria

Maximum if multiple criteria

Explanation

To get the maximum value from a set of numbers, use the MAX function.

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

=MAX(C6:G6)

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

Maximum value

Generic formula 

=MAX(range)

Related formulas 

Maximum value if

Minimum value

Minimum value if

Minimum if multiple criteria

Maximum if multiple criteria

Explanation

To get the maximum value from a set of numbers, use the MAX function.

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

=MAX(C6:G6)

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