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.


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
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 : 443