I'm trying to create a formula that will involves a range of numbers. For
instance, if a A1 is between 100-119, then result should be 1, if A1 is
between 120-139, then then the result should be 2 and so on. I can't figure
out the right combination to make it work. Thanks in advance for your help!

=IF(A199,INT((A1-100)/20)+1,"")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bsmile29" wrote in message
...
I'm trying to create a formula that will involves a range of numbers. For
instance, if a A1 is between 100-119, then result should be 1, if A1 is
between 120-139, then then the result should be 2 and so on. I can't
figure
out the right combination to make it work. Thanks in advance for your
help!

Check vlookup. The range form of that function (set the final argument to
TRUE or just leave it out) should do what you need.

"bsmile29" wrote:

I'm trying to create a formula that will involves a range of numbers. For
instance, if a A1 is between 100-119, then result should be 1, if A1 is
between 120-139, then then the result should be 2 and so on. I can't figure
out the right combination to make it work. Thanks in advance for your help!