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..