The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE and FALSE, and text values. The MAX Function can be easily tied together with other formula.
Syntax:
=MAX (number1,[number2]), ...)
- number1 – Number, reference to numeric value, or range that contains numeric values.
- number2 – [optional] Number, reference to numeric value, or range that contains numeric values.
Let’s look at the below example using the test data.
Student (A) | Test Score (B) |
Joe | 83 |
Tracy | 43 |
Sheila | 77 |
Dave | 76 |
Jennifer | 86 |
Tina | 91 |
Gertrude | 88 |
Max Function Example | Result |
=MAX(B3:B9) | 91 |
=MAX(B3,B5,B6) | 83 |
=MAX(B3:B4)+MAX(B8:B9) | 174 |
The MAX function ignores TRUE and FALSE values, and numbers entered as text, unless they are typed directly into the list of arguments.