Share via

Excel - IF Function - Adding a $1 to every number over target

Anonymous
2018-01-11T16:35:59+00:00

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.

Microsoft 365 and Office | Excel | For home | MacOS

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.

0 comments No comments

Answer accepted by question author

Anonymous
2018-01-13T19:40:11+00:00

=IF(D10>=C10;100+(D10-C10);0)

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2018-01-13T19:20:27+00:00

    =if(d10>=c10,100+c10-22,0)

    Was this answer helpful?

    0 comments No comments