.

MIN Function Dictionary

Function Dictionary Function Examples Function Categories

MIN            
 
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.
Syntax              
=MIN(Range1,Range2,Range3... through to Range30)
Formatting            
No special formatting is needed.
Example              
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
 =MIN(E23:E26)
Overall MIN £2,000
 =MIN(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