help with formula
 

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.

help with formula
 

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



On 1 Cze, 10:51, "Fergal" wrote:
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.

help with formula
 

Hi,

1 way. Note you don't need SUM

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

Mike

"Fergal" wrote:

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.