| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create "IF" function with a drop down list?
I have a worksheet with an option for a user to choose "0" to "3" in a cell
with a drop down list. Where "0" = N/A, "1" = NI (needs improvement), "2" = No, and "3" = Yes. This option is located in cell "E16". What I want to do is create an option for a new drop down list in adjacent cell "G16" which is based upon the choice made in "E16". A user could choose from several different appropriate answers for either "3", "2", "1", or "0". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I Get Out Of "DATA" ~ "CREATE LIST"? | Excel Discussion (Misc queries) | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| "Create a drop-down list from a range of cells" | Excel Worksheet Functions | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Make typing "jump" to matching item(s) in drop-down list? | Excel Discussion (Misc queries) | |||
Threaded Mode
