Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
I need the results as either a 1, 2 or 3.
if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
=IF(N6<200,1,if(N6<300,2,3))
This works because if the value is less than 200, the If stops looking after the first criterion. No need to give a minimum value after that. "Steve" wrote: I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
=IF(N6<200,1,IF(AND(N6199,N6<300),2,3))
you might want something if N6 is blank, perhaps =IF(N6="","",IF(N6<200,1,IF(AND(N6199,N6<300),2,3 ))) also if you want to extend this a bit more than skip the IF/AND function and go for a VLOOKUP 3 criteria the IF function can handle well but if it gets to be more that it's getting ugly plus once you get to 7 nested IFs it won't work and you have to find other ways around it -- Regards, Peo Sjoblom "Steve" wrote in message ... I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
Here is the solution, Try this
=IF(F17<200,"1",IF(F17=300,"3","2")) "Peo Sjoblom" wrote: =IF(N6<200,1,IF(AND(N6199,N6<300),2,3)) you might want something if N6 is blank, perhaps =IF(N6="","",IF(N6<200,1,IF(AND(N6199,N6<300),2,3 ))) also if you want to extend this a bit more than skip the IF/AND function and go for a VLOOKUP 3 criteria the IF function can handle well but if it gets to be more that it's getting ugly plus once you get to 7 nested IFs it won't work and you have to find other ways around it -- Regards, Peo Sjoblom "Steve" wrote in message ... I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
This will do what you asked...
=1+(A1200)+(A1300) although if A1 can be empty, then this... =IF(A1="","",1+(A1200)+(A1300)) or if A1 can be empty or contain non-numerical values, then this... =IF(ISNUMBER(A1),1+(A1200)+(A1300),"") -- Rick (MVP - Excel) "Steve" wrote in message ... I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
Thanks all. They worked great. And I could keep it simple, as 3 will be the
max that I need, and they'll never be blank. Thanks again, Steve "Need Help on axis problem in a chart" wrote: Here is the solution, Try this =IF(F17<200,"1",IF(F17=300,"3","2")) "Peo Sjoblom" wrote: =IF(N6<200,1,IF(AND(N6199,N6<300),2,3)) you might want something if N6 is blank, perhaps =IF(N6="","",IF(N6<200,1,IF(AND(N6199,N6<300),2,3 ))) also if you want to extend this a bit more than skip the IF/AND function and go for a VLOOKUP 3 criteria the IF function can handle well but if it gets to be more that it's getting ugly plus once you get to 7 nested IFs it won't work and you have to find other ways around it -- Regards, Peo Sjoblom "Steve" wrote in message ... I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, if, if with < &
Why are you addressing me, I didn't ask the question?
-- Regards, Peo Sjoblom "Need Help on axis problem in a chart" ft.com wrote in message ... Here is the solution, Try this =IF(F17<200,"1",IF(F17=300,"3","2")) "Peo Sjoblom" wrote: =IF(N6<200,1,IF(AND(N6199,N6<300),2,3)) you might want something if N6 is blank, perhaps =IF(N6="","",IF(N6<200,1,IF(AND(N6199,N6<300),2,3 ))) also if you want to extend this a bit more than skip the IF/AND function and go for a VLOOKUP 3 criteria the IF function can handle well but if it gets to be more that it's getting ugly plus once you get to 7 nested IFs it won't work and you have to find other ways around it -- Regards, Peo Sjoblom "Steve" wrote in message ... I need the results as either a 1, 2 or 3. if the number is <200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula partially works, but I think I have the < worng. =IF(N6<200,"1",IF(N6199<300,"2", ("3"))) Much appreciated, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|