Display Negative Numbers as 0

[kristin01]

I have an inventory sheet set up - the first column is Maximum Quantity, the 2nd column is Quantity Received, the 3rd is Not Yet Received. So I have a simple subtraction formula set up in the 3rd column (A1-B1) to display what we haven't received.

The issue is that sometimes we receive more items than what our maximum is listed as, so the 3rd column will list our Not Yet Received as a negative number. I'd really like it to display as plain 0 instead of a negative number without having to remove the forumula from the cell.

Any ideas?

[VBA Noob]

Maybe

=MAX(0,A1-B1)

VBA Noob

[kristin01]

Thanks so much!!!

[VBA Noob]

No problem

Thx for the feedback

VBA Noob