Microsoft KB Archive/49975

How to Find the Minimum Positive Number in Range of Numbers 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. REFERENCES "Microsoft Excel User's Guide," version 3.0, pages 119-120

KBCategory: kbusage KBSubcategory: Additional words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0 4.00 4.0 Last reviewed: November 2, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.