Formula help

[sdmccabe]

Could someone help with a formula to show excess wages? For example, if the
wage limit is $5000 and the upper limit is $4000, excess wages are $1000. I
need a formula that shows only the excess amounts, not minus (-) amounts.

 

[Michael]

Hi
if A1=5000
B1=4000
In C1, put:
=IF(A1-B1>0,A1-B1,"")

HTH
Michael Mitchelson