You say if a1=2 then "AB", but you also say if a1=2 then "BA" ???

"suddengunfire" wrote in message
...
I'm just struggling with finding a formula, which gives me results as
below:

if a1=1 or 2 or 3 then a2=AB
if a1=2 then a2=BA
if a1= value other than 1 or 2 then a2=CA

Any help would be appreciated, thanks in advance