Return a value, based on a defined range.

[elferous]

I know this should be fairly simple, but my brain's not working today...
I want a formula that will return a given value, based on where a given number falls within a range.
For example:
From 1-119, returns the number 2
From 120-230, returns the number 3
From 231-360, returns the number 4
And so on...

Thanks to anyone who can help me see the light on this!

[zbor]

Try this:

Please Login or Register  to view this content.