Thread: Formula help
View Single Post
  #2   Report Post  
Michael
 
Posts: n/a
Default

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

HTH
Michael Mitchelson


"sdmccabe" wrote:

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.