If(AND Testing 2 logics

[PCRIDE]

Hi, trying to get this to work and it's not working.

=IF(AND(W2>0,W2<=3),"1-3",FALSE) The value in W is 0 but I get a False.


Here is the entire formula
=IF(AND(W10>0,W10<=3,"1-3"),IF(AND(W10>3,W10<=7),"4-7"),IF(AND(W10>7,W10<=10),"7-10",IF(AND(W10>10,W10<=13),"10-13",IF(AND(W10>13,W10<=16),"13-16",IF(AND(W10>16,W10<=20),"16-20",IF(AND(W10>20,W10<=25),"20-25",IF(AND(W10>25,W10<=30),"25-30",IF(AND(W10>30,W10<=60),"30-60",IF(AND(W10>60,W10<=1000),"60+")))))))))


I am trying to categorize data in these categories.

 

[PCRIDE]

Ok, I just discovered the zero vaule was a decimal. The first one works, but I can't get the entire formula to work.

Any ideas?

 

[PCRIDE]

Those darn parenthesis!!

=IF(AND(W2>=0,W2<=3),"1-3",IF(AND(W2>3,W2<=7),"4-7",IF(AND(W2>7,W2<=10),"7-10",IF(AND(W2>10,W2<=13),"10-13",IF(AND(W2>13,W2<=16),"13-16",IF(AND(W2>16,W2<=20),"16-20",IF(AND(W2>20,W2<=25),"20-25",IF(AND(W2>25,W2<=30),"25-30",IF(AND(W2>30,W2<=60),"30-60",IF(AND(W2>60,W2<=1000),"60+",""))))))))))

This works now.

Sometimes just getting it out there makes you re-think it....