keeping a cell blank

[James]

how can i make a cell stay blank when the value is 0. especially when i have
a formula in that cell. for instance it may set to sum a range however that
range equals zero or some other formula that equals zero. I would like the
cell to stay blank. this is for a cover page report that pulls alot of data
from the enire workbook and i dont want it to be filled with a bunch of
Zero's

thanks

 

[David Biddulph]

Option 1: =IF(your_formula=0,"",your_formula)
Option 2: Format/ Conditional Formatting/ Cell Value Is/ equal to : 0/
Format font colour to white (or whatever your cell background colour is)
Option 3: Tools/ Options/ View/ deselect "Zero values"

 

[Kevin B]

Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center
named ZERO VALUES and remove the checkmark.

Hope this helps...

 

[FSt1]

hi
you could use an if formula in place of your other formula.
=if(sum(range=0),"",sum(range))
the formula would still be in the cell but the cell would display a blank.

regards
FSt1

 

[James]

Kevin B comes to the resue again.... Thanks

Click TOOLS/OPTIONS and on the VIEW tab, locate the checkbox at bottom center
named ZERO VALUES and remove the checkmark.

Hope this helps...