MAX
Returns the maximum of a list of arguments, ignoring text entries.
Syntax:
MAX(number1, number2, ... number30)
number1 to number30 are up to 30 numbers or ranges containing numbers.
Example:
MAX(2, 6, 4)
returns 6, the largest value in the list.
MAX(B1:B3)
where cells B1, B2, B3 contain 1.1, 2.2, and apple returns 2.2.
Application:
Finding the Highest Test Score
The MAX function is used to find the largest value in a set of data. A common application is in education to find the highest score on a test or assignment.
Scenario: A teacher wants to find the highest score among her students on a recent math quiz.
Table: Math Quiz Scores
Student | Score | ||
|---|---|---|---|
A | B | ||
1 | Alex | 88 | |
2 | Maria | 95 | |
3 | David | 79 | |
4 | Sarah | 92 | |
5 | Ben | 85 | |
6 | Emily | 95 |
Application of the MAX function:
To find the highest score, the teacher would apply the MAX function to the "Score" column.
MAX(Score)
Result:
The function would scan the values in the Score column (88, 95, 79, 92, 85, 95) and return the single highest value.
The result is 95.
Even though two students (Maria and Emily) have the same highest score, the MAX function simply returns the highest value itself, not how many times it appears or who achieved it. This is a simple and effective way to quickly identify the peak performance in a dataset.
Result for MAX(Score):
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof