» Find the minimum positive value in Microsoft Excel
CATEGORY - Excel Array Formulas , Other Q&A Formulas
VERSION - All Microsoft Excel Versions
The following numbers appear in cells A1:A5 Enter the following formula in cell D1: {=MIN(IF((A1:A5>0)*(A1:A5),(A1:A5)))}
The Result = 25
Please note: The formula is an Array Formula, after entering
the formula in the cell, press F2 and than press Ctrl+Shift+Enter
Book Store:
Recommended Books:
- Microsoft Windows XP Inside Out
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Getting to Yes: Negotiating Agreement Without Giving In
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
