Panasonic Home Business > Industrial Devices > Automation Controls Top > Service & Support > Frequently Asked Questions

When displaying the value in one cell in another cell, how do you display a blank as blank?

ID:
843
Issued:
Dec 25th, 2009
Updated:
May 17th, 2013

When displaying the value in one cell in another cell, how do you display a blank as blank?

ANSWER
If, for example, you want to display the value in cell A1 in the cell B1, and set the formula in cell B1 to =A1, when the value in A1 is blank, "0" is displayed in cell B1.

To get around this, set the formula in B1 to =IF(ISBLANK(A1),"",A1).

This formula displays "" in B1 if cell A1 is blank, and the value in A1 if cell A1 is not blank.
RELATED CATEGORIES

Did you solve your problems?

YES

NO

Search Keywords


If you still have problems with our products,

FEEL FREE TO CONTACT US

Return to top