Returns the largest value.
To get the larger of two values, use the MAX function. In our example, the formula used is:
where, A5 and B5 are cell references, being used against the argument of number1 and [number2]. You can add upto 255 numbers for which you want the maximum value.