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