Mattster2020

05-27-2009, 03:00 AM

Morning All,

I have used a formula to try and produce a grade depending on value in the following cells:

A3 = 20.07

C3 = 25.08

E3 = 27.00

G3 = 28.67

I3 = 32.25

The formula is as follows, cell E5 is where the grade is populated.

=IF(E5="","",IF(E5<A$3,"E",IF(E5>A$3<C$3,"D",IF(E5>C$3<E$3,"C",IF(E5>E$3<G$3,"B",IF(E5>I$3,"A"))))))

For some reason the formula doesnt work, can anyone point me where im going wrong?

Regards,

Matt

I have used a formula to try and produce a grade depending on value in the following cells:

A3 = 20.07

C3 = 25.08

E3 = 27.00

G3 = 28.67

I3 = 32.25

The formula is as follows, cell E5 is where the grade is populated.

=IF(E5="","",IF(E5<A$3,"E",IF(E5>A$3<C$3,"D",IF(E5>C$3<E$3,"C",IF(E5>E$3<G$3,"B",IF(E5>I$3,"A"))))))

For some reason the formula doesnt work, can anyone point me where im going wrong?

Regards,

Matt