Writing text in column F subject to the value found in column B

Please see excel file attached!
As you can see, column B include numeral values between 1 to 100 and the "-" sign in some cells.

I need a macro that will do the following:

If value in column B is between 1 and 10 (including 1 and 10) then text string in column F will be Page 1
If value in column B is between 11 and 20 (including 11 and 20) then text string in column F will be Page 2
If value in column B is between 21 and 10 (including 21 and 30) then text string in column F will be Page 3
If value in column B is between 31 and 10 (including 31 and 40) then text string in column F will be Page 4
If value in column B is between 41 and 10 (including 41 and 50) then text string in column F will be Page 5
If value in column B is between 51 and 10 (including 51 and 60) then text string in column F will be Page 6
If value in column B is between 61 and 10 (including 61 and 70) then text string in column F will be Page 7
If value in column B is between 71 and 10 (including 71 and 80) then text string in column F will be Page 8
If value in column B is between 81 and 10 (including 81 and 90) then text string in column F will be Page 9
If value in column B is between 91 and 100 (including 91 and 100) then text string in column F will be Page 10
If value in column B is - then text string in column F will be -

column F:

Please Login or Register  to view this content.

Here you go...

Please Login or Register  to view this content.

Glad I could contribute...Thanks for rep +. If this solves your query, please mark thread as solved.