Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL: Returning the Smallest Number Greater Than Zero


View products that this article applies to.

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.

↑ Back to the top


Keywords: KB60116, kbhowto

↑ Back to the top

Article Info
Article ID : 60116
Revision : 3
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 49