Explanation
In this example, the goal is to get the maximum quiz score (i.e.
MAX will return the maximum value in the data provided.
Text values and empty cells are ignored.
Because the quiz scores are all together, the data is supplied to MAX as a single range.
MAX is fully automatic.
If data changes, MAX will automatically recalculate.
To calculate a maximum value while ignoring errors,see this example.
LARGE function
TheLARGE functioncan also be used to return the maximum value in a set of data.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
