MIN Function Dictionary

Function Dictionary Function Examples Function Categories

Values Minimum
120 800 100 120 250 100  =MIN(C4:G4)
Dates Maximum
1-Jan-98 25-Dec-98 31-Mar-98 27-Dec-98 4-Jul-98 1-Jan-98  =MIN(C7:G7)
What Does It Do ?            
This function picks the lowest value from a list of data.
=MIN(Range1,Range2,Range3... through to Range30)
No special formatting is needed.
In the following example the =MIN() function has been used to find the lowest value for
each region, month and overall.
Sales Jan Feb Mar Region Min
North £5,000 £6,000 £4,500 £4,500  =MIN(C23:E23)
South £5,800 £7,000 £3,000 £3,000
East £3,500 £2,000 £10,000 £2,000
West £12,000 £4,000 £6,000 £4,000
Month MIN £3,500 £2,000 £3,000
Overall MIN £2,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