Multiple cells - Formula to insert text if lesser, equal or greater than X.

Hi, I was very kindly given a couple of solutions to an issue I'd been having with IF formulas. What I wanted to do was have a formula that would insert text if a numeric value in a range of cells was less than two.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

However, I'm trying to expand on this to have a third text option if the value = 2, in which it would say 'LastOne'.
I managed to come up with a formula that would do this for one cell, but I'm not sure how to take the next step to apply it to a range of cells like the ones above ^.

This is what I have so far, any help would be much appreciated:

Please Login or Register  to view this content.

Try:

Formula:

Please Login or Register  to view this content.

That works well for one cell, but how do I expand it to take in to account multiple Cells E.G. B2, B4, B5, B10:B11.

Any ideas?