Formula with multiple arguments?

[FreisingSean]

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?

 

[Bernard Liengme]

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(A6>A5,"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

 

[JE McGimpsey]

Assuming you mean "add a row", not "add a column":

A7: =CHOOSE(SIGN(A6-A5)+2,"Lower Risk","No Change","Higher Risk")

 

[Gord Dibben]

Do you have "rows" and "columns" confused?

What are the A, B , C and D representing?

Are 9 8 8 7 6 7 single numbers in cells across A1:F1?

In G1 enter =IF(F1>E1,"low",IF(F1<E1,"high","no"))

Copy down column G

If 9 8 8 7 6 7 are single numbers in A1:A6, just enter the formula in A7
then copy across to D7


Gord Dibben MS Excel MVP

 

[FreisingSean]

Thank you for your help.

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(A6>A5,"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

 

[Shane Devenshire]

Hi,

Here is a short solution

=IF(A6-A5,IF(A6>A5,"Low","High")&"er Risk","No Change")

Cheers,
Shane Devenshire