Argh! It still makes the same error!
This is what I write (It's in Danish):
=HVIS(Ordrebekræftelse!B10=C58,B58,HVIS(Ordrebekr æftelse!B10=C57,B57,HVIS(Ordrebekræftelse!B10=C5 6,B56,HVIS(Ordrebekræftelse!B10="",B59,""))))

Translated into English:
=IF(Ordre!B10=C58,B58,IF(Ordre!B10=C57,B57,IF(Ordr e!B10=C56,B56,HVIS(Ordre!B10="",B59,""))))

Can you see any error?

~J




"Bob Phillips" skrev:

aah! you didn't say that :-)

If A1 is on another sheet, say "Data Sheet", then use

=IF('Data Sheet'!A1="x1",1,IF('Data Sheet'!A1="x2",2,IF('Data
Sheet'!A1="x3",3,IF('Data Sheet'!A1="",FALSE,""))))


--

HTH

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


"jmm" wrote in message
...
Hi Bob,

Thank you for your quick replay. The problem is that, this is exactly that
I
wrote, but I still get the error... Is it because the value in A1 comes
for
another sheet?

~J

"Bob Phillips" skrev:

=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