All functions / Statistics

MAX

The largest number.

Syntax

=MAX(number1, [number2], …)

Arguments

• number: Numbers, cells or ranges.

Example

=MAX(B2:B10) → Highest value

Practise it

• AVERAGE, MIN and MAX
• Pay and overtime
• SORTBY, SEQUENCE and LET
• Challenge: quarterly sales summary
• Challenge: the league table
• Challenge: weekly payroll
• Challenge: customer survey results