» Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem:List1 (column A) includes numbers as well as blank cells.
When using the following formula to multiply each number in List1 by 3:
=IF(ISBLANK(A2),,A2*3)
Zeros are returned for all empty cells.
We want to adjust the formula so that blanks are returned for all empty cells in List1.
Solution:
Use two quote marks (""), as shown in the adjusted formula below, to indicate that a blank should be returned:
=IF(ISBLANK(A2),"",A2*3)
Book Store:
Recommended Books:
- Windows XP Annoyances
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Seven Habits Of Highly Effective People
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.
