Thread: Help with a Formula that is an "IF" "THEN" and pulls from 1st 2 # of another column

Does anyone know how i can set this up? It needs to pull from the 1st two digit of a four digit # in one column which determines its value.

Here's what i need it to do:

Column A - Each cell has a 4 digit #'s that start with
eigher 11,12,13,14,15,16,17 or 18.

Column B - Should calculate that IF column A begins with 11 then B=1,
if A begins with 12 then B=2, 13 then B=3, 14 then B=4, 15
then B=5, etc....

(Column A are room #'s in the hotel I work at. For example room #1234,#1458,#1633 or #1801. Column B is the floor the room is on. Room 1234 is on the 2nd floor, 1458 on the 4th floor and so on )

Any help would be great! I've been trying for days to figure it out!

Many thanks,
Kattia