Using the MAX Function in Excel
1. In cell B3, type the following formula:
2. Press Enter.
The
MAX function will compare the values in cells A1 and A2, and return the greater value in cell B3.
If you have more than two values to compare, you can include them in the MAX function separated by commas. For example, if you want to find the greatest value among cells A1, A2, A3, and A4, you can use the formula
Formula:
=MAX(A1,A2,A3,A4)
.
I hope that helps!