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
=if(or(and(b4>=234,b4<=544),and(b4>=801,B4<=1245))<"good",if(and(B4>544,B4<=800),"no Good","otherwise")
you may have to play with whether 544 is good or bad