ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/39346-formula-help.html)

sdmccabe

Formula help

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-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.

All times are GMT +1. The time now is 09:21 AM.