| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet looks good in print, not so good on-screen | Excel Discussion (Misc queries) | |||
| Just when you think you've got a good formula.... I need helpwith | Excel Discussion (Misc queries) | |||
| =%A%1, is this a good formula in Excel 2000? | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| How do I make this formula work =if(a1=(b10:b20),"good","bad"). | Excel Worksheet Functions | |||
Linear Mode
