Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"