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