A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
=IF(D10>=C10;100+(D10-C10);0)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am trying to write a formula that will add a $1 payout to every unit sold over a target number. For example, if someone has a target to sell 22 cases of a product and they sell 22, they will receive $100. For every case sold over 22, I want to add an additional $1 payout to the $100. Attached is what I have so far. I know how to set it up so they can get the $100 when they hit their target, I just can't figure out how to add the additional $1 to every case sold over their goal. Also, if they don't hit their target, they will get $0.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=IF(D10>=C10;100+(D10-C10);0)
=if(d10>=c10,100+c10-22,0)