S
SAP
I need to create a formula to work with a very large price list which carries
different part numbers with the respective description, List Price, weight,
and a Clasification Code according to the type of part.
My problem is that i quote the customer based on the different Clasification
codes; for intance,
P/N 123, with clasification code A, quote at List Price minus 10%
P/N 456, with clasification code B, quote at List Price minus 15%
P/N 789, with clasification code C, quote at List Price minus 20%
Hint: One part number has only one clasification code
One clasification code fit different part numbers (EX. for all the
parts for the Audi engines)
I created a VLookup formula that already brings me all the parts for the
quote but i need another column to show the selling prices. I tried the IF
function but it's limited to only a very few options.
Any help will be appreciated.
Thanks.
different part numbers with the respective description, List Price, weight,
and a Clasification Code according to the type of part.
My problem is that i quote the customer based on the different Clasification
codes; for intance,
P/N 123, with clasification code A, quote at List Price minus 10%
P/N 456, with clasification code B, quote at List Price minus 15%
P/N 789, with clasification code C, quote at List Price minus 20%
Hint: One part number has only one clasification code
One clasification code fit different part numbers (EX. for all the
parts for the Audi engines)
I created a VLookup formula that already brings me all the parts for the
quote but i need another column to show the selling prices. I tried the IF
function but it's limited to only a very few options.
Any help will be appreciated.
Thanks.