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.

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.

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.

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.

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.