I am assuming you have the numbers 9 8 8 7 6 7 in column A -- they are in
the range A1:A6
You want to compare A6 with A5
=IF(A6A5,"Lower Risk", IF(A6<A5,"Higher Risk","No change"))
No matter where you put this formula, if it is copied to the right it will
automatically change the As to Bs to compare the next column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"FreisingSean" wrote in message
...
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?