Cell values between 2 numbers - multiple answers required

Hello experts,

I'm trying to put a value in a cell based on another cells range.
For example, a cell has a value between 1 and 6 - cell 2 would show 4. Next cell has a value between 7 and 12 - cell 3 would show 5. etc.
I've attached a spreadsheet as an example.
As usual all your help is appreciated.

Thanks,
Paul.

Works great, thanks.
I went down the route thinking IF blah blah is less/ greater than etc. but couldn't get it to work.
Saved me a right load of work as the spreadsheet I'm editing has 750+ lines that need this workaround!

Cheers,
Paul.