.

MAX Function Dictionary

Function Dictionary Function Examples Function Categories

MAX            
 
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.
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.
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)

.

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