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
|