or()

[nick]

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

[SteveG]

Nick,


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

HTH

Steve

[Bob Phillips]

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"nick" <[email protected]> wrote in message
news:[email protected]...
> 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

[Ron Coderre]

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

[Biff]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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
>
>