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?

Posted by Barrie Davidson on November 16, 2001 8:21 AM


BarrieBarrie Davidson

Posted by Mark W. on November 16, 2001 8:24 AM

=MAX(0,A1-B1) (nt)