On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Sunday, November 9, 2014

MIN Function in MS-Excel

C
D
E
F
G
H
3
Values
Minimum
4
120
800
100
120
250
100
 =MIN(C4:G4)
6
Dates
Maximum
7
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.

B
C
D
E
G
22
Sales
Jan
Feb
Mar
Region Min
23
North
£5,000
£6,000
£4,500
£4,500
 =MIN(C23:E23)
24
South
£5,800
£7,000
£3,000
£3,000
25
East
£3,500
£2,000
£10,000
£2,000
26
West
£12,000
£4,000
£6,000
£4,000
28
Month MIN
£3,500
£2,000
£3,000
 =MIN(E23:E26)
30
Overall MIN
£2,000
 =MIN(C23:E26)



No comments:

Post a Comment

Popular Posts