Can I use a conditional if with a range <
 

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

Can I use a conditional if with a range <
 

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

"Motaad" wrote:

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

Can I use a conditional if with a range <
 

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


"Toppers" wrote:

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

"Motaad" wrote:

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

Can I use a conditional if with a range <
 

try:

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

HTH

"Motaad" wrote:

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


"Toppers" wrote:

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

"Motaad" wrote:

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