» Find the minimum positive value in Microsoft Excel
CATEGORY - Excel Array Formulas , Other Q&A Formulas
VERSION - All Microsoft Excel Versions
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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Investing for Dummies, Third Edition
- East of Eden (Oprah's Book Club)
- Microsoft Windows XP Inside Out
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
