If Statement

Liz J · Mar 10, 2009

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!

Roger Govier · Mar 10, 2009

Hi Liz

in cell C2
=IF(OR(A1=1,A1="?"),B2,"")

Sheeloo · Mar 10, 2009

Enter this in C2
=IF(OR(A1=1,A1="?"),B2,"")

Bob I · Mar 10, 2009

And what should C2 equal otherwise?

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

If Statement

Liz J

Roger Govier

Sheeloo

Bob I