MAX
What Does It Do ?
This function picks the highest value from a list of data.
Syntax
=MAX(Range1,Range2,Range3… through to Range30)
=MAX(Range1,Range2,Range3… through to Range30)
Formatting
No special formatting is needed.
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.
In the following example the =MAX() function has been used to find the highest value for
each region, month and overall.