Multiple Discounts for a Value

[mrfrogger]

Hi Folks,

I am wondering if there a pre-existing excel formula to subtract multiple percentages for a certain value.
For example, imagine you are offering a product which has several discounts depending on the quantity purchased. So, if you buy 100 of them, you will have an additional discount of 33%, if you buy 200, you will obtain a discount of the initial 33%+10% (that would be UNIT VALUE=-33%-10%=FINAL VALUE). It's possibly that I should add more values if purchase quantity increases.

Hope I pictured good enough the situation.

Thanks in advance!
Mr Frogger

 

[Marcelo Branco]

Nailed it!

I owe another beer also.

Thanks!

Yes, two beers



M.