Microsoft KB Archive/60116

= XL: Returning the Smallest Number Greater Than Zero =

Article ID: 60116

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q60116





SUMMARY
The Microsoft Excel MIN function returns the smallest number in a list of arguments. If the smallest number is zero (0), the function returns zero.

To return the smallest number greater than zero, enter the following array formula

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

where A1:A10 represents the range of the numbers. This returns an array of a single value with the smallest positive number.

NOTE: To enter an array formula in Excel for the Macintosh, press COMMAND+RETURN.

Additional query words: XL98 XL97 xl2002 xl2000 xl2001

Keywords: kbhowto KB60116

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.