help with formula

F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top