pushing results to another cell

[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

 

[Mike]

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

 

[Frank Kabel]

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)

 

[HGood]

Thanks Frank, I suspected that.

Harold

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)