if functions with more than 7 ifs (ranges are possible?)

[Guest]

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

 

[arno]

hi irwinko,

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

this is by design. use vlookup instead. see help for details.

arno

 

[Mangesh Yadav]

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


- Mangesh

 

[Guest]

=CHOOSE(A1,0,0,1,1,1,2,2,2,3,3,3,4,4,4)

where A1 is the cell with the # 1-14