Tiered Pricing SumIF Help

lewdow

New Member
Joined
Oct 8, 2008
Messages
25
Hi - I am trying to calculate the overall price based on a tiers of discounts:

Lower BandUpper BandList PriceDiscount%Discounted Price
07,500£10.000%£10.00
7,50115,000£10.003%£9.70
15,00125,000£10.006%£9.40
25,00135,000£10.009%£9.10
35,00140,000£10.0012%£8.80
40,001 50000+£10.0015%£8.50

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

This would be a tiered discount model - so the first 7,500 are sold at list price, the 7501st unit up to 15,000 are at 3% discount etc. It's not the case that buying 14,000 units would see all 14,000 at a 3% discount, the first 7500 would still be at 0% discount.

I've tried many times to resolve this using SUMPRODUCT from other examples and just can't get it to work! Anyone that can help would be much appreciated.

Thanks

L
 

Forum statistics

Threads
1,082,501
Messages
5,365,942
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top