how do I write a formula for if b4 is between 1 and 100 then good
 

how do I write a formula for if b4 is between 1 and 100 then good or between
101 and 200 no good or 201 and 300 stop?
Thanks

how do I write a formula for if b4 is between 1 and 100 then good
 

=if(b1<=100,"good",if(b1<=200,"No good","stop"))

"billy boy" wrote:

how do I write a formula for if b4 is between 1 and 100 then good or between
101 and 200 no good or 201 and 300 stop?
Thanks

how do I write a formula for if b4 is between 1 and 100 then g
 

My fault, I should have been a little more clearer. What I need is if b4is
betwwen 234 and 544 then good between 544 and 800 then no good between 801
and 1245 then good.
Thanks


"Toppers" wrote:

=if(b1<=100,"good",if(b1<=200,"No good","stop"))

"billy boy" wrote:

how do I write a formula for if b4 is between 1 and 100 then good or between
101 and 200 no good or 201 and 300 stop?
Thanks

how do I write a formula for if b4 is between 1 and 100 then g
 

=if(or(and(b4=234,b4<=544),and(b4=801,B4<=1245)) <"good",if(and(B4544,B4<=800),"no Good","otherwise")
you may have to play with whether 544 is good or bad

"billy boy" wrote:

My fault, I should have been a little more clearer. What I need is if b4is
betwwen 234 and 544 then good between 544 and 800 then no good between 801
and 1245 then good.
Thanks


"Toppers" wrote:

=if(b1<=100,"good",if(b1<=200,"No good","stop"))

"billy boy" wrote:

how do I write a formula for if b4 is between 1 and 100 then good or between
101 and 200 no good or 201 and 300 stop?
Thanks

how do I write a formula for if b4 is between 1 and 100 then g
 

Bj, something dont work, i get FALSE
Is the formula correct?
Thanks

"bj" wrote:

=if(or(and(b4=234,b4<=544),and(b4=801,B4<=1245)) <"good",if(and(B4544,B4<=800),"no Good","otherwise")
you may have to play with whether 544 is good or bad

"billy boy" wrote:

My fault, I should have been a little more clearer. What I need is if b4is
betwwen 234 and 544 then good between 544 and 800 then no good between 801
and 1245 then good.
Thanks


"Toppers" wrote:

=if(b1<=100,"good",if(b1<=200,"No good","stop"))

"billy boy" wrote:

how do I write a formula for if b4 is between 1 and 100 then good or between
101 and 200 no good or 201 and 300 stop?
Thanks

how do I write a formula for if b4 is between 1 and 100 then g
 

Try:

=IF((B4=234)*(B4<=1245), IF((B4544)*(B4<=800),"No good","Good"),"Other")

Tim C

"billy boy" wrote in message
...
My fault, I should have been a little more clearer. What I need is if b4is
betwwen 234 and 544 then good between 544 and 800 then no good between 801
and 1245 then good.
Thanks


"Toppers" wrote:

=if(b1<=100,"good",if(b1<=200,"No good","stop"))

"billy boy" wrote:

how do I write a formula for if b4 is between 1 and 100 then good or
between
101 and 200 no good or 201 and 300 stop?
Thanks