What is wrong with my Formula?

[Inc]

Im just learning Excel and Its been fine up to this one formula. As much as I do it I cant seem to figure out what I'm doing wrong so maybe someone here can help me?

=IF($L5>=0.9, “A”, IF(AND($L5>=0.8, $L5<0.9), “B”, IF(AND($L5>=0.7, $L5<0.8), “C”, IF(AND($L5>=0.6, $L5<0.7), “D”, “F”))))

Thanks.

[Bryan Hessey]

Im just learning Excel and Its been fine up to this one formula. As much as I do it I cant seem to figure out what I'm doing wrong so maybe someone here can help me?

=IF($L5>=0.9, “A”, IF(AND($L5>=0.8, $L5<0.9), “B”, IF(AND($L5>=0.7, $L5<0.8), “C”, IF(AND($L5>=0.6, $L5<0.7), “D”, “F”))))

Thanks.

Try

=IF($L5>=0.9,"A",IF($L5>=0.8,"B",IF($L5>=0.7,"C",IF($L5>=0.6,"D","F"))))

your double quotes appear fuzzy.

also, once you have eliminated A grade then you need not re-test for it.

---

[Carim]

Hi,

Everything is OK ...with exception of you inverted commas

Please Login or Register  to view this content.

HTH
Carim

[Inc]

That worked perfect. I cant thank you two enough. so... Thanks!