.

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

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