Thread: or()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nick
 
Posts: n/a
Default 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