MAX Formula in Excel

 

What Does It Do ?

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

image

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.

image

No comments:

Post a Comment