How to ignore negative numbers in a formula (display as 0)

[Natejss]

I'm creating an order sheet with very simple formulas that automatically subtract product on hand (col. A) from the product PAR (col. B) resulting in the total to order (col. C). The VERY simple formula in column C is "=B3-A3". What I can't seem to figure out is how to how to prevent the total to order (col. C) from registering negative numbers. Considering I can't order negative product, I'd like the column to simply display "0" whenever the result of B-A is negative.

[Mazzaropi]

Natejss, Good evening.

Try to use:

=IF(B3-A3<0,0,B3-A3)

I hope it helps.

[leelnich]

Or perhaps:

Please Login or Register  to view this content.