Setting up a per unit bonus formula
 

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

Setting up a per unit bonus formula
 

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


"Hamed parhizkar" wrote in
message ...
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