It does work good. Now I have a question, why when the values are C+ to a C-
it replies improved instead of Dropped. As you can see this is for school
grades. Thanks for the prompt answer.

"Maglor" wrote:

Jerry wrote:
I have two columns: Col1: A and Col2: C, some values may be Col1: C and Col2:
A or some other ones may be Col1: A and Col2: A. Values range from A to F.
What I want to display is: if Col2 is less than Col1 display "Dropped", if
col2 is greater than col1 display "Improved", if col1 and col2 are the same
display "No change". Your assistance is greatly appreciated. Jerry

If I understand your question correctly (the column explanation seems a
little bit confusing, my bad :-) ), this should solve your problem:

=IF(col1=col2,"no change",IF(col1col2,"dropped","improved"))

Of course you'll need to replace Col1 and Col2 by the corresponding
cells of each column.