IF function based on last character in string

[tbollo]

Hello,

If the last character in a string is equal to "M" I would like to return "Men's" and if the last charcter is "W" I would like to return "Women's" - what formula would work?

Thanks

 

[Joe4]

Let's say the value is in cell A1. Then one way would be:

=IF(RIGHT(A1,1)="M","Men's",IF(RIGHT(A1,1)="W","Women's",""))