trouble with < = > formula

[Steve Kay]

Hi everyone,
Having difficulty with getting a formula to work.
In Short I would like to formula to do the following:
IF A1= 0<X>50 then place a "50" in C1
IF A1= 50.1<x>100 then place 100 in C1
If A1= 100.0<X>150 then palce a 150 in C1

thanks for you help! Steve

 

[Jason Morin]

=CEILING(A1,50)

HTH
Jason
Atlanta, GA

 

[Don Guillett]

close
=if(and(a1>whatever,a1<whatever),1,2)

 

[Dave R.]

Your sign order looks weird, are you wanting '50' when A1 is between 1 and
49?

You can use AND , e.g.

IF(AND(A1<50,A1>=0),50,"")

just add on to complete your formula.

 

[Frank Kabel]

Hi Steve
one way:
IF(AND(A1>0,A1<=50),50,IF(AND(A1>50,A1<=100),100,IF(A1>100,A1<=150),150
,"don't know")))