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.
