MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)