Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula and Drop Down List
Is it possible to use an IF statement (or something similar) that refers to a
selection a user picks from a drop down list to pick a formula from a list of formulas? Assume I build custom desks. I have a list of all the formulas for cutting each part of for each style of desk. I would like the user to pick from a drop down list a desk style, i.e. rectangle, corner, etc. Next the user would enter the overall size of the desk. I would like the results to show all the cut sizes for each part of the custom desk. Is an IF statement the right way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula and Drop Down List
You can use dynamic validation
http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "unclebean" wrote: Is it possible to use an IF statement (or something similar) that refers to a selection a user picks from a drop down list to pick a formula from a list of formulas? Assume I build custom desks. I have a list of all the formulas for cutting each part of for each style of desk. I would like the user to pick from a drop down list a desk style, i.e. rectangle, corner, etc. Next the user would enter the overall size of the desk. I would like the results to show all the cut sizes for each part of the custom desk. Is an IF statement the right way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Drop down list and the cell next to it changes colours | Excel Discussion (Misc queries) | |||
adding a formula to items in a drop down list | Excel Discussion (Misc queries) | |||
formula on link and drop down list details | Excel Discussion (Misc queries) | |||
formula drop down list | New Users to Excel | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |