Formula with multiple arguments?
 

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?

Formula with multiple arguments?
 

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?

Formula with multiple arguments?
 

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

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


In article ,
FreisingSean wrote:

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?

Formula with multiple arguments?
 

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(F1E1,"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


On Mon, 29 Dec 2008 09:00:04 -0800, FreisingSean
wrote:

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?

Formula with multiple arguments?
 

Thank you for your help.

"Bernard Liengme" wrote:

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?

Formula with multiple arguments?
 

Hi,

Here is a short solution

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

Cheers,
Shane Devenshire

"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?