DISPLAY THE CONTENTS OF A CELL IN ANOTHER CELL DEPENDANT UPON THE.

[Guest]

How do I display the contents of a cell in another cell depending on what
another cell's formula has resulted in? What I want to do can be expressed
in this formula (but it doesn't work): =IF(G6=D11,K6). G6 has a =MAX
formula in it for selected cells in column D. The whole reason I'm trying to
do this is because I can't put more than six IF formulas in the cell that I
actually need them in, so I've divided them into three separate cells and
want them all to display in one.

 

[RagDyeR]

Under usual circumstances, long IF() formulas can be replaced with LOOKUP()
and/or VLOOKUP() functions.

Why don't you post exactly what you're trying to accomplish with you
original "long" formula.

As far as your question is concerned, remember that a formula can only
"bring in" (pull) data, it can't "send" (push) data to other cells.
If your example formula is one of three formulas that you're trying to
"send" to another cell, you could put a formula in *that* cell to "pull" the
data from the other 3 formula cells.

For example:

=IF(AND(G6=D11,H6=E11,I6=F11),K6+L6+M6,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I display the contents of a cell in another cell depending on what
another cell's formula has resulted in? What I want to do can be expressed
in this formula (but it doesn't work): =IF(G6=D11,K6). G6 has a =MAX
formula in it for selected cells in column D. The whole reason I'm trying
to
do this is because I can't put more than six IF formulas in the cell that I
actually need them in, so I've divided them into three separate cells and
want them all to display in one.