Microsoft KB Archive/49975

From BetaArchive Wiki

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


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.


"Microsoft Excel User's Guide," version 3.0, pages 119-120

KBCategory: kbusage


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.