|
|
#2
03-24-2015, 02:19 PM
|
|||
|
|||
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. 
|
| Tags |
| discount, excel 2010, range |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I calculate price discounts and also identify top customer? | cwarfox | Excel | 2 | 12-25-2014 04:42 AM |
 Formula Help
|
withersd46260 | Excel | 2 | 04-30-2014 08:33 AM |
|
What formula should I use?
|
TotalONE | Excel | 3 | 11-26-2013 01:30 PM |
|
Need Help w/Formula
|
OSCAR MARTINEZ | Excel | 1 | 09-28-2013 05:39 AM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
Windows 8 
Office 2013
Threaded Mode