=IF(A1="x1",1,IF(A1="x2",2,IF(A1="x3",3,IF(A1="",F ALSE,""))))

You didn't say what to do if none of these so I left it blank.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JMM" wrote in message
...
Hi,

I'm about to get gray hair here!

My problem goes like this:

I have three variables x1, x2 and x3. When this valiue is shown in CELL A1
I
need for the value in B1 to return 1, 2 og 3 and if no information in A1 I
need to have FALSE in B1.

Can someone help?

Thanks!
J