Keep getting #VALUE! in my cell - why??

[MarkA]

This is driving me nuts. Maybe something simple.

I have a simple formula

@if(D10+F10=0,0,(D10-F10))

I created this so that if D10 and F10 do not have a value yet I do not get zeros in the column. Now I get the word #VALUE! instead.

Thanks

 

[Philem]

Hullo. Check that D & F are number formatted.

HTH

P

 

[MarkA]

They are both formatted to Accounting but I reformatted to Number. Still the same problem. Also the cell that I have my formula in I checked the formatting.

Thanks

 

[phantom1975]

Give this a shot instead:

=IF(OR(D10="",F10=""),0,(D10-F10))

 

[Andrew Poulsom]

Is it that D10 and F10 may contain "" as a result of a formula? Try:

=IF(OR(D10="",F10=""),"",(D10-F10))

 

[MarkA]

IF(OR(D10="",F10=""),"",(D10-F10))

Thanks the above did the trick.
much appreciated.