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) - 28 Jan 2008 19:50 GMT
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
> How can i set up a formula to payout $100 for each unit an actual # is
> above
[quoted text clipped - 10 lines]
>
> Thanks