Assign a value(s) based on the content of a cel?

Hello- I need a couple formulas that would assign a certain value(s) based on a 3-digit course/section number.

Formula #1:
So for course 1 there are 36 possible levels. If the 3-digit section number is "101" or "201" then the level is 1, "102" or "202" then the level is 2, "103 or 203" then the level is 3 and so forth until we reach "136" or "236" for level 36.

Formula #2:
For course 2, if the 3-digit section number middle digit is "1" then the category is "Beginner", "2" the category "Amateur", "3" the category is "Intermediate", and "4" the category is "Expert". Then the last digit provides the level within that category (there are 9). So for example:

Column A Column B Column C
Section Category Level
111 Beginner 1
123 Amateur 3
149 Expert 9

I have tried nested IFs with ISNUMBER, SEARCH, and OR functions but couldn't make it work. Appreciate any help. Thanks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Looks right on but keep in mind there are 36 levels not 9. So section "110" or "210" is level 10 not level 0

Is formula #1 not ....

=RIGHT(A2,2)

101=(0)1, 110=10, 136=36

Yes, formula #1 works with 2 digits. Thank you so much. Formula #2 works but on the categories with 10 levels I had to make some adjustments, eg. =RIGHT(A2,1)+1 for section 140, level 1 expert (section 149 would be level 10). Thank you all!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.