cell equation ?
 

jahoobob Wrote:
Formula in d12 should be =If(b12-c120,0,b12-c12)
Thanks for the help but I am still having an issue with this.

b12=11
c12=21
d12=b12-c12 so then d12 should equal -10 but I need it to equal 0
I also need to account for 0's in the b or c column and I still need it
to display positive positive results.

Thank You
ws d


--
Custermd

Custermd Wrote:
Thanks for the help but I am still having an issue with this.

b12=11
c12=21
d12=b12-c12 so then d12 should equal -10 but I need it to equal 0
I also need to account for 0's in the b or c column and I still need it
to display positive positive results.

Thank You
ws d
Apologies,
I made the same mistake Marcster did in posting my formula, it should
be:
=IF(B12-C12<0,0,B12-C12)


--
jahoobob