negative numbers
Posted by Lee on November 16, 2001 8:17 AM
As you'll be able to tell from my question... I'm brand new to excel.
I need for my formula to only show positive numbers. In other words if I subtract $100 from $50 I need it to equal $0 not -$50.
I just need my final sum to zero out instead of showing negatives.
Does that make any sense?
Thanks
ldb
Posted by Barrie Davidson on November 16, 2001 8:21 AM
=IF(A1-B1<0,0,A1-B1)
Regards,
BarrieBarrie Davidson
Posted by Mark W. on November 16, 2001 8:24 AM
=MAX(0,A1-B1) (nt)
