Hi.
I am trying to accomplish the following, but I don't seem to find the right formula:
Cell A1 contains one of the following: A1 or A2 or B1 or B2
Cell A2 should contain a formula that generates specific text based on the A1 cell like this:
If A1 contains "A1", cell A2 should read "Elementary Proficiency"
If A1 contains "A2", cell A2 should read "Limited Working Proficiency"
If A1 contains "B1", cell A2 should read "Professional Working Proficiency"
If A1 contains "B2", cell A2 should read "Bilingual Proficiency"
I would really appreciate your help.
Bookmarks