Excel IF Formaulas, again

[funkylad20]

I always foget this how to do this one...
How do I dsiplay the result of one cell if another cell has 4 options? i.e. cell A1 can contain either 1,2,3 or 4. If it contains a 2, the result in B1 should be "ABC". If it contains a 4, it should be "CBA" etc.

[Ankou]

if formula gives only a true or false answer.

you might be better looking at arrays with hlookup etc.

[Old_Geezer]

Can you not have another if statement in each of the true and false results allowing you to further divide options by 2 ?

[ABerrant]

The good old nested IF, in the style of...

=IF(A1=1,"BCA",IF(A1=2,"ABC",IF(A1=3,"CAB",IF
(A1=4,"CBA",""))))

[vallaw]

=if(a1=2,"ABC",if(a1=2,"ACB",if(a1=3,"BCA",if
(a1=4,"CAB"))))

[vallaw]

I love nested if statements!

[funkylad20]

Cheers people! Vallaw you were spot on...the value if False almost gets omitted, so the "" at the end Aberrant, is not needed. That is where I was going wrong!

[ABerrant]

I always terminate my nested IFs with "" to eradicate logic or error messages.