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
|