Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF multiple arguments | Excel Worksheet Functions | |||
Multiple Arguments | Excel Discussion (Misc queries) | |||
sum with multiple arguments | Excel Worksheet Functions | |||
Multiple Arguments | Excel Worksheet Functions | |||
Multiple vlookup arguments | Excel Worksheet Functions |