Maximum value in Excel
This tutorial shows how to calculate Maximum value in Excel using the example below;
Formula
=MAX(range)
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.