Formula help

B

bsmile29

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!
 
B

Bob Phillips

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

bsmile29 said:
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
Click to expand...
help!
 
B

bpeltzer

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