Larger of two values

★ 20 minutes read

Just as it is with using other formulas in Excel to solve many different issues, you can also use Excel to determine the larger of two values. This post will guide you on how to determine the Larger of two values using a formula approach in Excel.

Larger of two values

Formula

The general formula showing how to determine the larger of the two cells’ values is:

=MAX(VALUE1,VALUE2)

Explanation

The MAX function is inbuilt in Excel and it allows a user to get the larger value between the two numbers.

Example 1

 

Larger of two values

 

Figure 1: determine the Larger of two values

 

In figure 1 above, the formula in F7 is:

=MAX(C7,D7)

The MAX function tests the two numbers provided and returns the larger value. In this example, it will compare values in cells C7 and D7 and return the larger one in the cell F7.

The general formula above can also be written with “IF” syntax thus:

= IF(C7>=D7, C7,D7)

The MAX function may be a compact and better replacement to the IF function. It contains no redundant references and also less prone to errors.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar