trying to make a cell either blank or zore value

[Dobbin0_4]

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

 

[Dobbin0_4]

sorry the formula is below!

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

 

[Pete_UK]

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

 

[Dobbin0_4]

Ok, Thanks Pete_UK

Any ideas why i can't put this in cell E5?

 

[David Biddulph]

Look up "circular reference" [in Excel help & in the archives of this
group.]