Setting up a per unit bonus formula

[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

 

[Rick Rothstein \(MVP - VB\)]

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