Can I use a conditional if with a range <>

M

Motaad

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???
 
M

Motaad

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????
 
T

Toppers

try:

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

HTH

Motaad said:
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????
Click to expand...
 
Top