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
|