Hi - I'm fairly new to this so apologies if this is a basic question:

I have a excel workbook (excel 2003) with data as such:

A 9 8 8 7 6 7
B 9 8 5 4 4 4
C 7 7 7 7 7 7
D 7 6 8 0 8 7

I would like to add a column at the end that does the following:

If the final number of the row (A6) is greater than the previous (A5) then
write "Lower Risk", If the final number (A6) is lower than the previous (A5)
then write "Higher Risk", If the number in the final row (A6) is the same at
the previous (A5) then write "No Change".

Is there a simple way of doing this?