View Full Version : Solved: Formula For Less Than / Greater Than

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.


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



05-27-2009, 03:15 AM
I am not sure this is exactly correct as you have 6 statuses and only 5 grades, but it should get you on track


05-27-2009, 03:37 AM
Hi Matt,

Note: this 'promotes; the ranking whenever the vlaue in E5 equals a value in A3:I3 (eg it will return a grading of 'C' when E5=27), but I'm not sure what your intention is.