How to Find the Minimum Positive Number in Range of NumbersLast reviewed: November 2, 1994 |
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 Last reviewed: November 2, 1994 |