Filter and map column based on last character

[kauser]

Hello, 

can you please let me know how can i mapping a column based on last character from previous column. 

Input 

NAME

DFHR1TA

DNCH1TB

RTYD1FG

WERY1OA

OUTY1ET

If last character from input column is between A-B then they should mapped into YES and anything else should be mapped into NO

Output 

NAME	TYPE
DFHR1TA	YES
DNCH1TB	YES
RTYD1FG	NO
WERY1OA	YES
OUTY1ET	NO

[griffinwelsh]

You can use a formula tool with if,right, and in functions. A screenshot of the required config is attached