sorry the formula is below!

=IF(d6=0,"",c6=0,"",(E5-D6+C6))


"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