Hi Dave

Part one is to make a reasonable mumber from your grades. Since A < B to a
computer, and probably not to your grade system, you need some numeric value
like

=VALUE(LEFT(A1,1))+(68-CODE(MID(UPPER(A1),2,1)))/10

This will return 5.3 from 5a and 5.1 from 5c, and you can compare them with
simple < = operators.

The rest is not clear to me. You say
"the grade field changes instantly I type in the latest score"
Please explain exactly how and where the changes appear.

I hope you are not asking for "keep the old formula result somewhere before
calculating the new one". That is not impossible, but requires either a
manual copy-paste or a macro used with dicipline. A formula cell does not
have a history of results, so if history is important then maybe another
design is required.

HTH. Best wishes Harald

"Dave" skrev i melding
om...
Hi

I have a worksheet which calculates a running average of student test
scores. An adjacent cell then has a vlookup function that displays a
grade based on the average test score and the level of the paper. The
grades are a mixture on numbers and letters, thus;

6a
6b
6c
5a
5b
5c
4a
4b

I have to provide "encouraging feedback" to the students after every
paper and report on whether their grade has gone up or down. My
problem is that the grade field changes instantly I type in the latest
score. Is there any way that I could flag up a change of grade, and
whether it was an improvement or not,perhaps by changing the colour
formatting of the grade displayed.

Any help would be greatly appreciated,

Dave