# If statement based on positive and negative numbers.

1. ## If statement based on positive and negative numbers.

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!  Register To Reply

2. ## Re: If statement based on positive and negative numbers.

Probably better done with a lookup table. Can you provide a small sample workbook with some dummy data for testing? Are you a teacher?  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 