Forum Discussion
How to use multiple discount levels in a formula to calculate total
What formula would I use to calculate the Total. The formula has to apply the discounts levels. Seats Price per seat Total 1,100 $10.00 2,400 $10.00 5,100 $10.00 ...
THANK YOU
Hans,
Using the 5100 seats, I applied your formula and got the same total you show....$48, 530.00
But if I calculate it manually, I get a different total: $48,730.00
I interpreted your original description differently. I assumed that you meant:
First 1000 seats no discount, from 1000 to 3000 seats 5% discount, all seats above 3000 seats 7% discount.
Your new description looks like:
First 1000 seats no discount, next 3000 seats (so up to 4000) 5% discount, all seats above 4000 seats 7% discount.
If that is really what you want, simply change the number 3000 in B12 to 4000. The formula can remain the same.
- You are correct....I was wrong. Thank you
