-----Original Message-----
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(A ND
(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!!!!!!!!
.
If you can send me your file...or send me a
file/spreadsheet with bogus numbers in it, I may be able
to play with it. I have used if/ands before... but not to
this extent.. but you never know.

Mike