Need formula for below condition

[sharadmaxwell]

Capture.JPG

In above image
AT B1
i used Forumala
=RIGHT(A1,2)
it comeds value 11
so i need a fomula in B1 itself
if result of formula comes 11 then AAA
if result of foumula comes 12 then BBB
if result of foumula comes 13 then CCC
please guide

[kersplash]

See if this gets you started;

Please Login or Register  to view this content.

[sharadmaxwell]

sir in this only one condition is ther i wnat all three condition

[kersplash]

There's the second one;

Please Login or Register  to view this content.

[sharadmaxwell]

Thanks it works

[AliGW]

Please take a moment to re-read forum rule #1. Next time you post, please use a more meaningful thread title.

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.