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