Have excel return a cell if value is between the value of two cells

I'm trying to let Google Spreadsheets return a text value from one cell if the value is in the right interval. This is my formula so far:

=IF(AND(B4>=C37), A37 , IF(AND(B4>=C38 , B4=C39 , B4=C40 , B4=C41 , B4=C42 , B4

Can anyone tell me what I'm doing wrong?