| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Question
Hi everyone,
I'm kind of in a bind here, and I'm trying to figure out how to do this in Excel. Basically, what I want to do, is I want to create a drop down list that provides Text, but assignes the text a numiercal value to be used in another formula. Example. The drop down list contains the following in A1 and in A2: Excellent Poor Terrible I need Excellent to have a value of 2, Poor to have a value of 1, and Terrible to have a value of 0 So in Cell A3, I can have the formula =A1*A2 and it will give me a numerical value. Can this be done? If so how, cause I am stumpted... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique drop down list | Excel Worksheet Functions | |||
| re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
| Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| formatting drop down list | Excel Discussion (Misc queries) | |||
Threaded Mode
