hi. i have one price list, which has many options and prices accordingly, but it gives out almost 2000 combinations, which makes a lot difficulty for me. what i want is that, those price list must b checked by a great mathematician and i must get the values which i need to add.
m attaching a excel sheet alongwith, plz check sheet 2, n read the example below.
let say-> "157 gsm matt (d)" material with "Single" and "100" quantity makes price=17
"157 gsm matt (d)" material with "Double" and "100" quantity makes price=24
right now i have to enter prices for each combinations like these, which comes out to b around 2000
what i want is as follows:
"157 gsm matt (d)" material base price=7
add for "Single" = 5
add for "Double" = 12
add for "100" quantity = 5
i want this for every item ( one price to add n get rid of so many combinations ).