Using IF with the OR function?

[R Haney mcse]

Another question from the unitiated:

The equation I need to figure out:

=IF(RIGHT(B2,1)="A","X"," ")

This works great for helping me to populate the C column with X's when the B
column's value has an "A" in the far right position. Super. But, now I also
need it to look for a "W" in the far-left position and do the same thing
("X") How can I do this in one equation using the OR function?:

[If B2 has an A (far right) OR a W (far left) insert an X into C2]

Thanks!!!!

~ Ralph

 

[Trevor Shuttleworth]

Ralph

=IF(OR(RIGHT(B2,1)="A",LEFT(B2,1)="W"),"X"," ")

Regards

Trevor