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.