BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points
MIN
Returns the smallest number in a range.
Syntax
MIN(number1, [number2], ...)
Statistical Functions.
A worked example
=MIN(C2:C9)
Returns $890
Scans the eight order values and returns the smallest — Fairmont's $890 order.
Where it goes wrong
Text and blanks are ignored, so a column of numbers stored as text returns 0.
Practise MIN
Knowing what a function does and being able to write it from memory are different skills. These close the gap.