Making formula cell blank

  • Thread starter Thread starter Will Lester
  • Start date Start date
W

Will Lester

Hi all,
I have inserted the following formulas in cells in Column G:
=D7-E7+F7+G6
=D8-E8+F8+G7
=D9-E9+F9+G8
....and so on.

How do I make cells in column G appear blank if cells D through F
contain no data?

I hope I have explained this clearly enough.

Thank you very much.


....Will
 
If all the cells are blank then you would get 0 in the cell with the
formula in. One way of hiding this is to apply Format | Conditional
formatting such that if Cell Contents Is 0 then set the foreground
colour to the same colour as the background (usually white) - the cell
will appear empty.

Hope this helps.

Pete
 
Your formula (in column G, you wrote) contains G. A nice circular reference.
Any result but an error would be a surprise.

For your question: Consider a custom format for your cells containing the
formula. The format for zero should be "" (an empty string).

Joerg
 
Back
Top