I am trying to build an IF statement that will display specific data from a particular cell (letter grade) based on a percentage increase or decrease which will be either a positive or negative number. Just can't get the negative numbers to show the correct cell data. I've tried using less than and greater than with the negative numbers but not working. Below is what I started with. Example: negative .1 through negative 1 should point to the cell that populates a grade of C and negative 1.1 through negative 2 should point to cell that populates a grade of D etc...

=IF(X19=0,"N/A",IF(W9>=5%,$A$24,IF(W9>=4%,$A$25,IF(W9>=3%,$A$26,IF(W9>=2%,$A$27,IF(W9>=1%,$A$28,IF(W9>=0%,$A$29,IF(W9<0%,$A$31,IF(W9<=-1%,$A$32,IF(W9<=-2%,$A$33,IF(W9<-3%,$A$35)))))))))))

Thanks!