IF statements

[thestones757]

I was using an If statement, thought it was set up correctly but as I've been entering data it hasn't represented data like i wanted it to. It represents a grade scale for my classes where D7 is my final percentage



=IF(D7>97,"A+",IF(93<D7<96.9,"A",IF(90<D7<92.9,"A-",IF(87<D7<89.9,"B+",IF(83<D7<86.9,"B",IF(80<D7<82.9,"B-",IF(77<D7<79.9,"C+",IF(73<D7<76.9,"C",IF(70<D7<72.9,"C-",IF(60<D7<69.9,"D",IF(D7<59.9,"E","E")))))))))))


for some reason it only displays either an A+ or an E.


Any ideas why this doesn't work?

I have never used an IF statement inside an IF statement but I thought I had done it correctly. Thanks for the help.

 

[NBVC]

Try:



=LOOKUP(D7,{0,60,70,73,77,80,83,87,90,93,97},{"E","D","C-","C","C+","B-","B","B+","A-","A","A+"})

if you want to display blank until cell is filled, then:

=IF(D7="","",LOOKUP(D7,{0,60,70,73,77,80,83,87,90,93,97},{"E","D","C-","C","C+","B-","B","B+","A-","A","A+"}))

 

[thestones757]

thanks for the help