The Excel Formula : MAX

Dear Friends.
We sometimes required to find the maximum value in in the given range . Its very painful and time taking tasks if you have to do this manually, specially in a large database. So, here you will find the ways to get the output within seconds using the Excel inbuilt formulas.

Values								Maximum
120		800	100		120	250		800		=MAX(C4:G4)
Dates								Maximum
01-Jan-98		25-Dec-98	31-Mar-98		27-Dec-98	04-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)