Try this:

=If(Or(A1={1,2,3}),"AB",If(A1=4,"BA","CA"))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"suddengunfire" wrote in message
...
On 31 Jul, 13:49, suddengunfire wrote:

if a1=1 or 2 or 3 then b1=AB also if a1=2 then b1=BA and also if a1=
value other than 1 or 2 then b1=CA

He, he, I got lost in my own explanations

of course I meant if a1=1 or 2 or 3 then b1=AB and if a1=4 then b1=BA
and if a1=any value other than 1, 2, 3 and 4 then b1=CA

it's hard with Excel but without it it's even harder..