Maximum value

An excel formula to maximum value

Sponsored Link

 Maximum value
=MAX(range)

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.

Sponsored Link

0 votes. 0 / 5