Excel Formula Query - Adding OR to function

[usmanhussain13]

Hi aLL,

Have the following formula which works fine, however want to add to it so that it looks for not just the text "A1" but also "B1", how can i amend the below formula?

=IF(RIGHT(TRIM(D2),2)="A1","YES","NO")

Thanks,

 

[usmanhussain13]

Just to add, will probably need it up to G1, so A1 B1 C1 D1 E1 F1 G1

 

[Fluff]

How about
=IF(OR(RIGHT(TRIM(D2),2)={"A1","B1"}),"YES","NO")