View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hamed parhizkar Hamed parhizkar is offline
external usenet poster
 
Posts: 45
Default 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