Help Needed ASAP

[casst]

I need to subtract one cell from another cell. However, I don't want to see
any negative numbers, instead I only want a zero. For example:

If A2 is 300 and B2 is 150 than C2 should be 150
If A3 is 150 and B3 is 300 than C3 should be 0 (not -150)

Is this possible, and if so, how do I write the formula.

Thanks

 

[Brad]

=max(0,a2-b2)
=max(0,a3-b3)
Copy this two equations as necessary

 

[Bernard Liengme]

=IF(A2-B2>0,A2-B2,0)
OR
=IF(A2>B2,A2-B2,0)
OR
=IF(A2-B2,A2-B2,0) ' A positive value is treated as TRUE
OR
=(A2<B2)*(A2-B2)
best wishes

 

[casst]

Thank you - this worked!!!

=max(0,a2-b2)
=max(0,a3-b3)
Copy this two equations as necessary