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

G

Guest

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
 
G

Guest

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
 
G

Guest

=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
 
T

Tim C

Try:

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

Tim C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find value within a range and extrapolating....(tiered commission) 1
MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING 3
Percentage Formula in Excel 3
Tricky if function 2
Function help requested please 6
How do I use 'between' 95% and 100% for a nested IF function? 4
Formula for adding time 2
need help creating formula 2

Top