Formula based on selection of dependent drop downs

[vilas desai]

Dear Experts
I want to enter a formula in a Cell based on the selections I make in Original Drop down and 4 drop dependent downs Please see attached file. Unprotect with "Secret"
The formula is in J9. Drop dons are in Col C
Also please help me remove the Protected sheet.
Best regards
Vilas Desai

[HansV]

Please provide sufficient information. "I want to enter a formula in a Cell" doesn't tell us much.

And what do you mean by "remove the Protected sheet"?

[vilas desai]

Sorry about that, Hans. Please refer to work sheet named est-wt
1. Cell J9 has a formula that is entered manually in formula bar. There is currently no link between the formula and the Drop down box values in Cells C5 to C9.

The current drop down selections are
Filler--> Flat --> StandardFold --> One Side --> Circular and the formula is in J9 is "=(I9*(G9*3.14+F9+8)/100)"

Problem Statement: If the drop down selection changes to a different combination such as
Filler--> Flat --> J Fold --> One Side --> Circular
I would like to have a different formula in J9 such as "=(I9*(G9*3.14+F9+15)/105)"

I will have a table of formulas for every combination in a tabular manner which can be used as V-Lookup.

2. Please ignore about "Protected Sheet"

Thanks and Best regards
Vilas Desai

[HansV]

If I don't know which formulas you want to use I cannot help you.

[vilas desai]

I understand Hans. Sorry again . But I will soon share with you the formulas.
Best regards
Vilas Desai