Thread: cell equation ?
View Single Post
  #2   Report Post  
jahoobob
 
Posts: n/a
Default


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