| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tiered Pricing Calculations
How can I calculate total pricing based on multiple priicing & usage tiers
(IF Then or AND): Usage - Price 0-50,000 = $1 50,001 - 150,000 = $.75 150,001+ = $.50 Example: 250,000 units Need to automate the following: 50,000 = $50,000 50,001 - 150,000 = $75,000 150,001+ = $50,000 Total Due = $175,000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent - Tiered Pricing VBA | Excel Discussion (Misc queries) | |||
| Urgent - Tiered Pricing | Excel Discussion (Misc queries) | |||
| Tiered Pricing | Excel Programming | |||
| IF then statements-Tiered PRicing | Excel Worksheet Functions | |||
| Tiered Pay Scale Calculations | Excel Discussion (Misc queries) | |||
Threaded Mode
