I think you need something along the lines of:

=IF(OR(D6="",C6=""),"",E5-D6+C6)

but you will not be able to put this in cell E5.

Hope this helps.

Pete

On Sep 16, 5:25*pm, Dobbin0_4
wrote:
I am trying to make a cell show a blank of zero value either is fine
here is the formula

=SUM(E5-D6+C6)

With cell E5 being the cell that needs to return a zero value if no data is
added to either cells D6 or C6

I have tried the "IF" function but am getting stuck with it here is what i
have doen with the IF function. I know i am doing something wrong but can't
see where!

Any help is greatly appreciated
Thanks