=IF(AND(A1=1,A1<=2),0,IF(AND(A1=3,A1<=5),1,IF(AN D(A1=6,A1<=9),2,3)))


- Mangesh



"irwinko" wrote in message
...
ok in one cell that i have there could be a possibility of 1-14 and i want
for example if i enter 1 or 2 in another cell it will come up 0, then for
3
or 4 or 5 it to come up 1, then for 6 or 7 or 8 or 9 it to come up 2. Is
this
at all possible because i can't seem to get it to work