| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need an incentive form with id#,name, days, bonus, bonus, tot. | Excel Discussion (Misc queries) | |||
| How do I set up a formula to calculate a bonus? | Excel Worksheet Functions | |||
| Formula to figure bonus | Excel Worksheet Functions | |||
| formula for bonus or penalty | New Users to Excel | |||
| Bonus formula help needed | Excel Worksheet Functions | |||
Threaded Mode
