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
|