MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can you format a cell to be blank after.....


Posted by Ty Agboola on July 10, 2001 11:35 AM

cell 1 has nothing in it.
cell 2 references cell 1.
cell 2 displays "0"
I want cell 2 to have nothing in it as well.


thanks


Posted by Eric on July 10, 2001 11:43 AM

=if(isblank(a2)=true,"",a2)

Assuming the data you want to report is in a2.
Hope that helps : Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1) and there is nothing in that cell? cell 2 references cell 1. cell 2 displays "0" I want cell 2 to have nothing in it as well. thanks

Posted by Mark W. on July 10, 2001 11:47 AM

General;-General;

...will work; however if cell 2 actually contains
a 0 then it won't be displayed.

Note: You can substitute other types of formatting
(e.g., 0.00) for "General". : Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1) and there is nothing in that cell? cell 2 references cell 1. cell 2 displays "0" I want cell 2 to have nothing in it as well. thanks

Posted by Bob on July 10, 2001 1:09 PM

A third way is to use conditional cell formatting. You can set it so if value = 0 then text color = white. White on white background does not appear. The other two solutions posted are more elegant for your specific case, but this can handle those cases where you actually have a cell value that is zero and is supposed to be zero.