How do you display IF statement results in a different cell

[Guest]

I am creating a bunch of if statements but want the results to return to
cells on a different worksheet

Thanks in advance

 

[Pete_UK]

A formula can only affect the cell that it is in - you can't "push"
data to another cell. Perhaps if you could give us some more detail of
what you want to do, we might be able to help you further.

Pete

 

[Guest]

You can't say:-

=if(this cell = this value, another cell = that value)

If you want the result in another cell then you can copy the result of the
formula with

=A1

Mike

 

[Guest]

hi,
The if statement must be located in the cell that the results will be
returned to.

Regards
FSt1

 

[Guest]

Thanks, basically I have a summary sheet which I want to display data of
"current in progress works". On the other worksheet I have the a column that
tells me which company is in progress (100 companies) so what I want to do is;

on worksheet 2 read colum O3 if there is a 1 (meaning in progress) then take
the company name A3 and display it in summary sheet cell B5, the O and A rows
always are the same so if O33 has a 1 A33 is always the company that relates
to that cell, I have seperate IF statements for each row at this point.

Now not all 100 companies will be "in progress" so to avoid a bunch of void
cells under each other I want to put all result in B5 (summary sheet) under
each other so its a clean flowing list

Does that make sense?

Thanks for your help in advance
Neall

 

[Bernie Deitrick]

Neall,

The easiest way to do this is to use Data Filters on column O of worksheet 1, and use them to
display only cells with 1 as the value. All other rows will be hidden. Don't use another sheet at
all....

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thanks I like the Idea however, when I filter it truncates the other summary
information, is there anyway I can just effect that one column when I filter?

 

[Bernie Deitrick]

Neall,

That is the idea behind filtering - to hide the other information that doesn't have your desired
value in the selected field.

If you have some blank cells or you have multiple rows of data but only one flag (your table is not
a true database) then you need to fill in the blanks with formulas to pick up the desired 1 values.

HTH,
Bernie
MS Excel MVP