Thread: If Statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default If Statement

And what should C2 equal otherwise?

=IF(OR(A1="1",A1="?"),B2,"???????")

Liz J wrote:

I want to write an if statement that says if cell A1 equals either "1" or "?"
then cell C2 equals cell B2. How do I create that if statement?

Thanks for your help!