Thread: [Solved] formula for discounts
View Single Post
 
Old 03-24-2015, 02:19 PM
Snakehips Snakehips is offline Windows 8 Office 2013
Advanced Beginner
  
Join Date: Mar 2015
Posts: 36
Snakehips is on a distinguished road
Default
Abarxax,

Structure it as below example starting with the low volume discount and then progress through the larger discounts.
Eg 1 -1000 0%, 1001 - 5000 5%, 5001 - 10000, 10%, 10000 + 15%

Assuming Qty in B2 and Unit Price in C2 then
=B2*C2*(1-IF(B2<1001,0%,IF(B2<5001,5%,IF(B2<10001,10%,15%))) )

Alternatively you could use a lookup table approach.

Hope that helps.
Reply With Quote