=CHOOSE(A1,"AB","BA",CA")

--
__________________________________
HTH

Bob

"suddengunfire" wrote in message
...
On 31 Jul, 14:39, Pete_UK wrote:

Also, your 3rd condition clashes with your first when A1=3.

a1 was supposed to be a dynamic cell. When you type in "1" in it then
cell b1, which is supposed to contain a formula, should display
"AB" (according to my example from previous posts). When you type "2"
in cell a1 - then b1 displays "BA". And again when you type, for an
instance, "3" - then cell b1 should display "CA"

I thought it was possible, sorry for messing up