software

can anyone tell me if i could do the following:
A1 A2
1 =IF(OR(A1=1,2,3,4,5),quot;xquot;,quot;?quot;)
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}),quot;xquot;,quot;?quot;)

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=542264=IF(OR(A1={1,2,3,4,5}),quot;xquot;,quot;?quot;)--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

A2: =IF(OR(A1={1,2,3,4,5}),quot;xquot;,quot;?quot;)

Note the braces { } above

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

XL2002, WinXPquot;nickquot; wrote:

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

Hi!

Try one of these:

=IF(OR(A1={1,2,3,4,5}),quot;xquot;,quot;?quot;)

=IF(ISNUMBER(MATCH(A1,{1,2,3,4,5},0)),quot;Xquot;,quot;?quot;)

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

=IF(ISNUMBER(MATCH(A1,F1:F5,0)),quot;Xquot;,quot;?quot;)

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

=IF(OR(A1=F1:F5),quot;xquot;,quot;?quot;)

Biff

quot;nickquot; gt; wrote in message
...
gt; can anyone tell me if i could do the following:
gt; A1 A2
gt; 1 =IF(OR(A1=1,2,3,4,5),quot;xquot;,quot;?quot;)
gt; 2
gt; 3
gt; 4
gt; 5
gt; If the above is incorrect, can someone tell me how to put the values in an
gt; or statement with out typing A1 all the time forall the values...Thanks in
gt; advance
Thank you all...it worked!

quot;SteveGquot; wrote:

gt;
gt; Nick,
gt;
gt;
gt; =IF(OR(A1={1,2,3,4,5}),quot;xquot;,quot;?quot;)
gt;
gt; HTH
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=542264
gt;
gt;