Setting up a per unit bonus formula

  • Thread starter Thread starter Hamed parhizkar
  • Start date Start date
H

Hamed parhizkar

How can i set up a formula to payout $100 for each unit an actual # is above
budget.

For example, if actual sales was 52 and budget was 50 then the cell should
read $200. 54 to 50, then it should read 400 and so on.

Also if actual is less that budget then the 100 should be deducted for each
unit.

Please help.

Thanks
 
Subtract the budgeted amount from the actual sales amount and multiply by
100. If B3 has the budgeted amount and A3 has the actual amount, then...

=100*(A3-B3)

Rick
 
Back
Top