MAX (Returns the maximum value in a list of arguments)

What Does It Do?

This function picks the highest value from a list of data.

Syntax

=MAX(Range1,Range2,Range3... through to Range30)

Formatting

No special formatting is needed.

Example

In the following example the =MAX() function has been used to find the highest value for each region, month and overall.