.

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

TAMIL NADU Seventh MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 7TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD