MAX Function Dictionary

Function Dictionary Function Examples Function Categories

Values Maximum
120 800 100 120 250 800  =MAX(C4:G4)
Dates Maximum
1-Jan-98 25-Dec-98 31-Mar-98 27-Dec-98 4-Jul-98 27-Dec-98  =MAX(C7:G7)
What Does It Do ?            
This function picks the highest value from a list of data.
=MAX(Range1,Range2,Range3... through to Range30)
No special formatting is needed.
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
Overall Max £12,000


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download