| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tiered Pricing Calculations
Well, I apologize. I mean, if your prices are still:
1-50000 = $1 50001-150000 = .75 150k+ = .5 ...then the formula should read: =SUMPRODUCT(--(A1{0,50000,500000}),A1-{0,50000,500000},{1,-.25,-.25}) Sorry for the error above. The last { } shows the differential as you go through the tiers. =============== "Actually, I *am* a rocket scientist." *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| 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) | |||
Hybrid Mode
