Free Online Tutorials on Spreadsheets

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 - 2019 Explainry.com | All Rights Reserved