Formuladrill

MAX practice

MAX returns the largest value in its arguments. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

MAX(value1, [value2], ...)

What people get wrong

MAX(0, x) is the standard way to floor a value at zero, for example tax only when there is a profit.

Excel exercise that use MAX

Often used together with: MIN

Practice MAX now

The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.

Start practicing free