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