Hiding Things In Excel

[KN3M3SIS]

I have many cells that reference and make calculations from other cells. When these cells have no infomration in them they dislay "#DIV" or "0" or whatever else. I do not want the cells to have anything in them until something is entered.

Is there a way to keep the contents of these cells hidden until this is done?

 

[bluedragon2]

What about putting error checking in your formulas. If you get an error, have it displayed as blank. For example:

If you are getting a 0, put:

=IF(<your formula>=0,&quot;&quot;,<your formula>)

or

=IF(ISERROR(<your formula>),&quot;&quot;,<your formula>)





Blue

If I wasn't Blue, I would just be a Dragon...