MAX

Posted on 17-01-2020 , by: admin , in , 0 Comments

MAX

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.

Values Max
120 800 100 120 250 800  =MAX (C4:G4)
Dates Max
01-Jan-98 25-Dec-98 31-Mar-98 27-Dec-98 04-Jul-98 27-Dec-98  =MAX (C7:G7)

Example:

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

Sales Jan Feb Mar Region Max
North £5, 000 £6, 000 £4, 500 £6, 000  =MAX (C23 :E23)
South £5, 800 £7, 000 £3, 000 £7, 000
East £3, 500 £2, 000 £10, 000 £10, 000
West £12, 000 £4,  000 £6, 000 £12, 000
Month Max £12,000 £7,000 £10,000
 =MAX (E23:E26)
Overall Max £12,000
 =MAX (C23:E26)

Leave a comment