can anyone tell me if i could do the following:
A1 A2
1 =IF(OR(A1=1,2,3,4,5),"x","?")
2
3
4
5
If the above is incorrect, can someone tell me how to put the values in an
or statement with out typing A1 all the time forall the values...Thanks in
advance

Nick,


=IF(OR(A1={1,2,3,4,5}),"x","?")

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=542264

=IF(OR(A1={1,2,3,4,5}),"x","?")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"nick" wrote in message
...
can anyone tell me if i could do the following:
A1 A2
1 =IF(OR(A1=1,2,3,4,5),"x","?")
2
3
4
5
If the above is incorrect, can someone tell me how to put the values in an
or statement with out typing A1 all the time forall the values...Thanks in
advance

Try this:

A2: =IF(OR(A1={1,2,3,4,5}),"x","?")

Note the braces { } above

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"nick" wrote:

can anyone tell me if i could do the following:
A1 A2
1 =IF(OR(A1=1,2,3,4,5),"x","?")
2
3
4
5
If the above is incorrect, can someone tell me how to put the values in an
or statement with out typing A1 all the time forall the values...Thanks in
advance

Hi!

Try one of these:

=IF(OR(A1={1,2,3,4,5}),"x","?")

=IF(ISNUMBER(MATCH(A1,{1,2,3,4,5},0)),"X","?")

F1:F5 = 1;2;3;4;5

=IF(ISNUMBER(MATCH(A1,F1:F5,0)),"X","?")

Array entered using the key combination of CTRL,SHIFT,ENTER:

=IF(OR(A1=F1:F5),"x","?")

Biff

"nick" wrote in message
...
can anyone tell me if i could do the following:
A1 A2
1 =IF(OR(A1=1,2,3,4,5),"x","?")
2
3
4
5
If the above is incorrect, can someone tell me how to put the values in an
or statement with out typing A1 all the time forall the values...Thanks in
advance

Thank you all...it worked!

"SteveG" wrote:


Nick,


=IF(OR(A1={1,2,3,4,5}),"x","?")

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=542264