» 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:
- Marketing Planning for Services
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Microsoft Outlook 2002 for Dummies
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Excel Version 2002 Step by Step
No comments have been submitted.
