| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Various rates applied to various cumulative balances
I am looking to apply different rates to different balances within a running
total. For example, let's say I want to pay incentives at a rate of .5 for the first $10, from $10.01 to $49.99 to receive a rate of .55 and anything above $50 to receive .6. The total for the sales is $100. So, the calculation would be ($10*.5)+(39.99*.55)+($50*.6). How would I do this in Excel so that as entries were made, the incentives would be automatically calculated based on the cumulative total? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to draw cumulative frequency curve in Excel | Charts and Charting in Excel | |||
| help! cumulative returns | Excel Worksheet Functions | |||
| How do I do a cumulative frequency graph? | Charts and Charting in Excel | |||
| Pivot Table groups & cumulative totals | Excel Discussion (Misc queries) | |||
| Charting: Displaying cumulative totals at top of stacked columns | Charts and Charting in Excel | |||
Threaded Mode
