Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |