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)