pushing results to another cell

  • Thread starter Thread starter HGood
  • Start date Start date
H

HGood

Is it possible to display the results of a calculation in another cell
besides the cell that holds the formula?

I want to display "Next QTR" in a column of cells in certain circumstances.
Is it possible to force the results to display in another cell besides the
one that holds this formula?

If the formula is in A3, can I force it to display the result, not only in
A3, but also in A4 without entering anything in A4?

Thanks,

Harold
 
Copy the contents in A3 and use the Paste Special command, then, within the
Paste Special dialog box select "Paste Link". This should do the trick.

Mike
 
Hi
no this is not possible using formulas. They can only return a value to
the cell they reside in. so you have to enter a separate formula in
your other column (referencing the existing formula)
 
Thanks Frank, I suspected that.

Harold

Frank Kabel said:
Hi
no this is not possible using formulas. They can only return a value to
the cell they reside in. so you have to enter a separate formula in
your other column (referencing the existing formula)
Click to expand...
 
Back
Top