Can I use a conditional if with a range <>

[Guest]

I am trying to write a formula in one column where it states if a number in
the second column is less than 25 or = to or greater than one, to give me a
one in the other column. If it doesn't fit that criteria give me a two.
This is what I am using but it isn't working. =if(b1<25>=1,1,2). Any
suggestions???

 

[Guest]

=IF(AND(B1>=1,B1<25),1,2)

 

[Guest]

=IF(AND(B1>=1,B1<25),1,2)

 

[Guest]

Thanks that helped. Can I do more than one range? i.e.: 1-25, 26-50, and
51-99 all nested in the same formula????

 

[Guest]

Thanks that helped. Can I do more than one range? i.e.: 1-25, 26-50, and
51-99 all nested in the same formula????

 

[Guest]

try:

=LOOKUP(A1,{1,26,51},{1,2,3})

HTH

Thanks that helped. Can I do more than one range? i.e.: 1-25, 26-50, and
51-99 all nested in the same formula????

 

[Guest]

try:

=LOOKUP(A1,{1,26,51},{1,2,3})

HTH

Thanks that helped. Can I do more than one range? i.e.: 1-25, 26-50, and
51-99 all nested in the same formula????