Explanation
In this example, the goal is to get the minimum quiz score (i.e.
MIN will return the minimum value in the data provided.
Text values and empty cells are ignored.
Because the quiz scores are all together, the data is supplied to MIN as a single range.
MIN is fully automatic.
If data changes, MIN will automatically recalculate.
SMALL function
TheSMALL functioncan also be used to return the minimum value in a set of data.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
from a set of numeric data.
Related videos
How to calculate maximum and minimum values
