» Creating Formulas that Only Return Results from Non-Blank Cells
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
We want to create a formula that only returns a result from the non-blank cells in List1.
Solution:
Use the ISBLANK function as shown in the following formula:
=IF(ISBLANK(A2)=FALSE,A2,"")
To return text values only, use the ISTEXT function as shown in the following formula:
=IF(ISTEXT(A2),A2,"")
To return numeric values only, use the ISNUMBER function as shown in the following formula:
=IF(ISNUMBER(A2),A2,"")
Book Store:
Recommended Books:
- Marketing Plans That Work, Targeting Growth and Profitability
- Windows XP Pocket Reference
- Investing in Real Estate, Fourth Edition
- The Interpretation of Financial Statements
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
