BeginnerStatistical Functions
Find the largest and smallest order
Identify the extremes in a column of values.
MAX · MIN
4 min10 points
MAX
Returns the largest number in a range.
Syntax
MAX(number1, [number2], ...)
Statistical Functions.
A worked example
=MAX(C2:C9)
Returns $4,250
Scans the eight order values and returns the largest — Delta Roofing's $4,250.
Where it goes wrong
Returns 0 rather than an error when a range contains no numbers at all.
Practise MAX
Knowing what a function does and being able to write it from memory are different skills. These close the gap.