Microsoft KB Archive/49975

{| = How to Find the Minimum Positive Number in Range of Numbers =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q49975 The information in this article applies to: - Microsoft Excel for Windows versions 2.x, 3.0 and 4.0 - Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

If you have a range of both positive and negative numbers in Microsoft Excel and need to find the minimum positive number in that range, use the formula

=MIN(IF(A1:A4>0,A1:A4)) where you change A1:A4 to the range you want to use. You must enter the formula as an array formula by pressing CTRL+SHIFT+ENTER.