Enter this in C2
=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!