Thanks for your help, I will use VLOOKUP!



-----Original Message-----
hi Craig,
Excel is limited to 7 nested staements. For your issue I
would use
VLOOKUP. Change your listing as follows (split the range
numbers):
A B C
1 10 a <- you have to decide where the 10
belongs
11 20 b
....

Now if your cell D1 contains the number 33 use the
following formula to
get the character:
=VLOOKUP(D1,A1:C20,3,1)

HTH
Frank


Craig S. wrote:
I am using the "IF" & "AND" statments to have a certain
number look into a table and pick a ceratin cell.

The formula I used will not accept the last AND
statement. My question is, does excel limit the number
of "AND" statements you can use in a formula?

My next question is, is there another function I can
use.

I have a listing as follows:

1-10 = a
10-20 =b
20-30 =c
30-40 =d

I have a cell the contains the value of 33. I want the
next cell to contain the formula that will return the
value of "d" to this cell. I know I can use IF & AND
functions, but the formula below is giving me an error.




=IF(AND(C222=$B$232,C222<=$C$232),$AA$234,IF(AND
(C222=$B$235,C222<=$C$235),$AA$237,IF(AND
(C222=$B$238,C222<=$C$238),$AA$240,IF(AND
(C222=$B$241,C222<=$C$241),$AA$243,IF(AND
(C222=$B$244,C222<=$C$244),$AA$246,IF(AND
(C222=$B$247,C222<=$C$247),$AA$249,IF(AND
(C222=$B$250,C222<=$C$250),$AA$252,IF(AND
(C222<=$C$253,C222=B253),$AA$255,0))))))))


Thanks for any help!!!!!!!!


.