Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell selection and IF with multiple resutls
Hi all,
Is it possible in excel to do teh following 1- move the selection to a new location based on a certain criteria? for example, IF(A1=C4 Then move the cell selection to D4) 2- make an IF statement with multiple results...for example, =IF(A1=A3, 100 AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3, Then the current cell should be 100 and the cell next to it should be 200, and the cell next to that one should be 300...and so on... Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell selection and IF with multiple resutls
A formula can only change the value of the cell that it is in, it
can't change the value of another cell. So for your first question, you would need to put a formula in cell D4, something like: =IF(A1=C4,cell,"") where cell needs to be your reference to the "selected" cell. For your second question, again a formula cannot change another cell's contents. However, you could put: =IF(A1=A3,100,"") in what you call the "current" cell (assume this is D4), and in the cell next to it (D5 or E4 ??) you could put this: =IF(D4="","",D4+100) That cell could be copied down or across to increase the other cells by 100 each time. Hope this helps. Pete On Sep 8, 6:45*am, Dream wrote: Hi all, Is it possible in excel to do teh following 1- move the selection to a new location based on a certain criteria? for example, IF(A1=C4 Then move the cell selection to D4) 2- make an IF statement with multiple results...for example, *=IF(A1=A3, 100 AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3, Then the current cell should be 100 and the cell next to it should be 200, and the cell next to that one should be 300...and so on... Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell selection and IF with multiple resutls
Thanks Pete, for your response. This is very useful.
"Pete_UK" wrote: A formula can only change the value of the cell that it is in, it can't change the value of another cell. So for your first question, you would need to put a formula in cell D4, something like: =IF(A1=C4,cell,"") where cell needs to be your reference to the "selected" cell. For your second question, again a formula cannot change another cell's contents. However, you could put: =IF(A1=A3,100,"") in what you call the "current" cell (assume this is D4), and in the cell next to it (D5 or E4 ??) you could put this: =IF(D4="","",D4+100) That cell could be copied down or across to increase the other cells by 100 each time. Hope this helps. Pete On Sep 8, 6:45 am, Dream wrote: Hi all, Is it possible in excel to do teh following 1- move the selection to a new location based on a certain criteria? for example, IF(A1=C4 Then move the cell selection to D4) 2- make an IF statement with multiple results...for example, =IF(A1=A3, 100 AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3, Then the current cell should be 100 and the cell next to it should be 200, and the cell next to that one should be 300...and so on... Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell selection and IF with multiple resutls
You're welcome - thanks for feeding back.
Pete On Sep 8, 1:24*pm, Dream wrote: Thanks Pete, for your response. This is very useful. "Pete_UK" wrote: A formula can only change the value of the cell that it is in, it can't change the value of another cell. So for your first question, you would need to put a formula in cell D4, something like: =IF(A1=C4,cell,"") where cell needs to be your reference to the "selected" cell. For your second question, again a formula cannot change another cell's contents. However, you could put: =IF(A1=A3,100,"") in what you call the "current" cell (assume this is D4), and in the cell next to it (D5 or E4 ??) you could put this: =IF(D4="","",D4+100) That cell could be copied down or across to increase the other cells by 100 each time. Hope this helps. Pete On Sep 8, 6:45 am, Dream wrote: Hi all, Is it possible in excel to do teh following 1- move the selection to a new location based on a certain criteria? for example, IF(A1=C4 Then move the cell selection to D4) 2- make an IF statement with multiple results...for example, *=IF(A1=A3, 100 AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3, Then the current cell should be 100 and the cell next to it should be 200, and the cell next to that one should be 300...and so on... Thank you- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cell selection | Excel Discussion (Misc queries) | |||
How do I change the color for cell selection in excel? | New Users to Excel | |||
Multiple cell selection | Excel Discussion (Misc queries) | |||
Change Cell background color by selection | Excel Worksheet Functions | |||
Getting a chart to stop if the formula resutls in a blank cell | Excel Worksheet Functions |