See

http://www.cpearson.com/excel/nested.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Craig S." wrote in 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(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!!!!!!!!