Microsoft Excel Functions & Formulas

Use the MIN and IF functions to find the lowest

non-zero value in a range

The sales for a fiscal year are recorded by month. During the year

the month with the lowest sales has to be determined. If the list

contains all sales from the year, we simply use the MIN function to

get the lowest value. However, if we want to find the lowest sales

sometime during the year and we don’t have sales figures available

for some of the months, we have to use the IF function to take care

of the zero values. Combine the MIN and IF functions in an array

formula and use conditional formatting to shade the lowest value.

4

To detect the lowest non-zero value in a range:

1. ...