Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a quantity rebate
Hi there,
I would like to calculate the discount or penalty. Do you have an elegant way? A simplified "Discount" table: From To Discount 1 1 1000 lumpsum penalty 2 50 500 lumpsum penalty 51 100 250 lumpsum penalty 101 150 0 151 200 -1% discount on Turnover 201 250 -2% 251 ... -3% .... 100.000 999.999 -5% If my volume is in a certain bracket I need to calculate a percentage on the turnover if it is worth a discount or return the lumpsum penalty. Thanks for your insights, Sige |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a quantity rebate
My solution looks like:
=IF(LOOKUP(B2;Rebates)<0;LOOKUP(B2;Rebates)*A2;LOO KUP(B2;Rebates)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating inventory quantity | Excel Worksheet Functions | |||
calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Find duplicates then calculate..??? | Excel Worksheet Functions | |||
how do i calculate the order quantity? | Excel Worksheet Functions |