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)
|
