help with formula

[Fergal]

I have the following formula: =SUM(C9-E9-F9)
This formula is then dragged down for many rows and works perfectly except
for one thing, in the rows that have no data in them, the cell shows up as
£0.00. Is it possible to have it that the cell remains blank until data is
entered in the row?
I hope this makes sense to you,
Thank You for any replies.

 

[Jarek Kujawa]

format the cells as Custom # ##0;-# ##0;

 

[Mike H]

Hi,

1 way. Note you don't need SUM

=IF(COUNT(C9,E9,F9)=3,C9-E9-F9,"")

Mike