| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display list or word
I would like to set up cell, "B" to show one of three things based on the
contents of "A" cell. The three choices for cell "B" are List #1, List #2 or the word "none". Please help... -- KM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display list or word
=IF(A1="X","List#1",IF(A1="Y","List#2","None"))
Provide more information if you need more specific solution. Thanks "Mossykel" wrote in message ... I would like to set up cell, "B" to show one of three things based on the contents of "A" cell. The three choices for cell "B" are List #1, List #2 or the word "none". Please help... -- KM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display list or word
I've tried entering a formula like that in the Data Validation area with the
list box checked but it won't automatically produce the "none" word. It just shows a blank list for that. Works great at showing my other lists though. Any suggestions? -- KM "Gaurav" wrote: =IF(A1="X","List#1",IF(A1="Y","List#2","None")) Provide more information if you need more specific solution. Thanks "Mossykel" wrote in message ... I would like to set up cell, "B" to show one of three things based on the contents of "A" cell. The three choices for cell "B" are List #1, List #2 or the word "none". Please help... -- KM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display one letter of a word in a cell | Excel Worksheet Functions | |||
| IF statement to Display word on Time | Excel Discussion (Misc queries) | |||
| How do I display number into form of text or word? | Excel Worksheet Functions | |||
| would like to know the formula amount and display word | Excel Discussion (Misc queries) | |||
| have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
Linear Mode
