If Statement on Excel version 2002

[biz]

Could you please give me an IF statment formula re. below condition:

IF Cell B2 = "A1", "A2", "A3", then give me result in Cell B2, otherwise 0.

A1, A2, A3 are not cell numbers--they are certain ratings.

 

[JE McGimpsey]

One way:

=IF(SUM(COUNTIF(B2,{"A1","A2","A3"})),B2,0)

 

[David Hepner]

In a cell other than b2 enter this formula:

=IF(OR(B2="A1",B2="A21",B2="A3"),B2,0)