Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional statements: how do I make reslts show up in dif cell
I am setting up multiple conditional statements. In the current one, I am
typing information (the conditional statement) into a cell, but rather than the results show up in that cell, I want the results to show up in different/multiple cells. For instance. I am inputting information into ER17. The statement I am writing is "=IF(EG17="20214", (EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on the right side of the "=" contain information; those cell references to the left of the "=" is where I want the information/result to show up. How do I do this? Please advise right away. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional statements: how do I make reslts show up in dif cell
If you're trying to set these various cells to values contained in other
cells, you need to write separate formulas for each cell. Example: in EN17 you need to write =EG20, and so on. Trying to write an IF-THEN-ELSE statement is not going to get you anywhere. Dave -- Brevity is the soul of wit. "achieve" wrote: I am setting up multiple conditional statements. In the current one, I am typing information (the conditional statement) into a cell, but rather than the results show up in that cell, I want the results to show up in different/multiple cells. For instance. I am inputting information into ER17. The statement I am writing is "=IF(EG17="20214", (EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on the right side of the "=" contain information; those cell references to the left of the "=" is where I want the information/result to show up. How do I do this? Please advise right away. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional statements: how do I make reslts show up in dif cell
A formula will only return a value to the cell it is in. It cannont send
values to other cells. If you want values in other cells, then those other cells must each contain a formula of their own. In your example, put this formula into cell EN17: =IF(EG17="20214",EG20,"") And then in EO17 put this formula: =IF(EG17="20214",EH20,"") etc, etc.... HTH, Elkar "achieve" wrote: I am setting up multiple conditional statements. In the current one, I am typing information (the conditional statement) into a cell, but rather than the results show up in that cell, I want the results to show up in different/multiple cells. For instance. I am inputting information into ER17. The statement I am writing is "=IF(EG17="20214", (EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on the right side of the "=" contain information; those cell references to the left of the "=" is where I want the information/result to show up. How do I do this? Please advise right away. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional statements: how do I make reslts show up in dif cell
Formulas can only "pull" data into the cell in which the formula is written.
They cannot "send" data to other cells. In EN17 enter =IF($EG$17="20214",EG20,"") Drag/copy across to EQ17 Gord Dibben MS Excel MVP On Mon, 13 Nov 2006 12:41:02 -0800, achieve wrote: I am setting up multiple conditional statements. In the current one, I am typing information (the conditional statement) into a cell, but rather than the results show up in that cell, I want the results to show up in different/multiple cells. For instance. I am inputting information into ER17. The statement I am writing is "=IF(EG17="20214", (EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on the right side of the "=" contain information; those cell references to the left of the "=" is where I want the information/result to show up. How do I do this? Please advise right away. Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional statements: how do I make reslts show up in dif cell
"achieve" wrote in message
... I am setting up multiple conditional statements. In the current one, I am typing information (the conditional statement) into a cell, but rather than the results show up in that cell, I want the results to show up in different/multiple cells. For instance. I am inputting information into ER17. The statement I am writing is "=IF(EG17="20214", (EN17=EG20,EO17=EH20,EP17=EI20,EQ17=EJ20), "")" where the cell references on the right side of the "=" contain information; those cell references to the left of the "=" is where I want the information/result to show up. How do I do this? Please advise right away. Thanks. You'll need to write a VBA code like: IF condition THEN action1 action2 Else action4 End IF Try posing the question to the microsoft.public.excel.programming group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a conditional format recognize a formula in a cell | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How can I make a none value cell not show as zero on a chart? | Charts and Charting in Excel | |||
how can i make a cell always show text in caps | Excel Worksheet Functions | |||
How to make a cell show totals | Excel Discussion (Misc queries) |