Tip Printed from ExcelTip.com

---

Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells


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)