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
Formula based on selection of dependent drop downs
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Formula based on selection of dependent drop downs
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula based on selection of dependent drop downs
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"?
And what do you mean by "remove the Protected sheet"?
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Re: Formula based on selection of dependent drop downs
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
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
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula based on selection of dependent drop downs
If I don't know which formulas you want to use I cannot help you.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 307
- Joined: 16 Mar 2011, 09:33
Re: Formula based on selection of dependent drop downs
I understand Hans. Sorry again . But I will soon share with you the formulas.
Best regards
Vilas Desai
Best regards
Vilas Desai