Formula with multiple arguments?

  • Thread starter Thread starter FreisingSean
  • Start date Start date
F

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?
 
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
 
Assuming you mean "add a row", not "add a column":

A7: =CHOOSE(SIGN(A6-A5)+2,"Lower Risk","No Change","Higher Risk")
 
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
 
Thank you for your help.

Bernard Liengme said:
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
Click to expand...
 
Hi,

Here is a short solution

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

Cheers,
Shane Devenshire
 
Back
Top