MIN

Posted on 18-01-2020 , by: admin , in , 0 Comments

MIN

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.

Values Min
120 800 100 120 250 100  =MIN (C4:G4)
Dates Max
01-Jan-98 25-Dec-98 31-Mar-98 27-Dec-98 04-Jul-98 01-Jan-98  =MIN (C7:G7)

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

Leave a comment