Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a function which does the following, but cannot find one:
[to be put in cell B2] =(CASE A2 when "AAA" then "Some text" when "BBB" then "Other Text" else "") Is anything, other than a bunch of nested IF statements, possible? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amount or Numbers in Words | New Users to Excel | |||
Spellnumber | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Need help on Select Case | Excel Worksheet Functions |