Larger of two values

Use

Returns the largest value.

Description

To get the larger of two values, use the MAX function. In our example, the formula used is:

=MAX(A5,B5)

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.

Example

Formula:

Result:

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved