keeping a cell blank
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"
--
David Biddulph
"James" wrote in message
...
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
|