MIN Function (Functions in Excel)
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) |
0 comments:
Post a Comment