Microsoft KB Archive/62727

Ignoring Zeros with the MIN Function

PSS ID Number: Q62727 Article last modified on 11-04-1994

2.x 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

= SUMMARY =

The MIN function returns the smallest number in a range of data. If the smallest number is zero (0), the function returns zero.

To return the smallest number greater than zero, enter the following array formula, where A1:A10 represents the range of the numbers:

=MIN(IF(A1:A10>0,A1:A10))

This returns an array of a single value with the smallest positive number.

To return the smallest number disregarding zero, enter the following array formula:

=MIN(IF(A1:A10<>0,A1:A10))

Note: Array formulas must be entered by typing the command and then pressing CTRL+SHIFT+ENTER.

= Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00 =

Copyright Microsoft Corporation 1994.