Hey guys,

I am trying to make an excel gradebook for my class and I am trying to figure out the final grade (i.e: A, B,C,D) based on exam grades. I am new to excel and I understand that if/then statements help with this and I am trying to define 89.99 or greater as an A, 80 to 89.99 as a B, 70 to 79.99 as a C, and otherwise then its a D. So far I have this for my cell but I get the #value! error

=IF(D8>=90, “A”), IF(D8>=80, "B"), IF(D8>=70, "C", "D")

What's exactly wrong with this if/then?

Thanks