S
Steve
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(N6>199<300,"2", ("3")))
Much appreciated,
Steve
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(N6>199<300,"2", ("3")))
Much appreciated,
Steve