» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Business Analysis with Microsoft Excel (2nd Edition)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Financial Statement Analysis with S&P insert card
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
