or()
 

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

or()
 

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

or()
 

=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

or()
 

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

or()
 

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

or()
 

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