How to make column dependencies in exel and use it in formulas?

Question

excel

There is a task to make automatic calculation of the cost price. There are some parameters: price, type of paper (matte, gloss), density (from 90 to 340), size.
How can I set the dependencies in the table?

So, for example, when choosing "Paper type: gloss or mat", the corresponding column "Density" was loaded, and when choosing the "Density" value, a value equal to the sum of this density was loaded.

"Paper type", "Density" - drop-down list.
Table file

Answer 1

You need to add a last column with an if condition.
For example:
A1 - drop-down list type of paper (gloss, matte)
In column F, there will be a formula like If (A1="gloss", FORMULA which should be subject to gloss, FORMULA if not gloss).
If you have only two values ​​in the drop-down list, then the formula will look like this, if there are more, then instead of the last formula, if not gloss, you should enter one more IF function. it will look something like this, If(A1="glossy", FORMULA which should be glossy,IF(A1="matt", FORMULA which should be matt,FORMULA if not glossy and not matte).
if still if you need help, you can write to the mail (in the profile), I will help write the function.