CASE statement equivalent
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
|