Microsoft Excel Functions & Formulas

Use the MIN function to search for the lowest

non-zero number

In this example, the smallest non-zero number in a range has to be

found and marked automatically. Use the MIN function to get the

lowest value in a range, then use the IF function to check whether

the number is not zero. Insert this formula as the formatting crite-

rion for conditional formatting, and the lowest numbers will be

colored as desired. This function finds the lowest number, whether

it is positive or negative.

4

To search for the lowest non-zero number:

1. In a worksheet, enter numbers in cells A1:D10 (or copy the

values in Figure 10-11) and select the range.

2. On the Format menu, ...