One way:

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

In article ,
biz wrote:

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.