how do I output result of formula to another cell?
 

I would like to output the result of a formula to another cell (say formula
in a1 and result of a1's formula in a2)
I do not want a formula in a2, it must remain a completely blank cell, until
the value of the formula in a1 is sent to a2.

how do I output result of formula to another cell?
 

Formulas can't do that. They can return values to the cell that holds them.

Francois wrote:

I would like to output the result of a formula to another cell (say formula
in a1 and result of a1's formula in a2)
I do not want a formula in a2, it must remain a completely blank cell, until
the value of the formula in a1 is sent to a2.

--

Dave Peterson

how do I output result of formula to another cell?
 

Francois -

Copy A1 and go to Edit / Paste Special. Under the paste options there is one
to paste only the value (and not the formula) hope this helps!

Tonya

"Francois" wrote:

I would like to output the result of a formula to another cell (say formula
in a1 and result of a1's formula in a2)
I do not want a formula in a2, it must remain a completely blank cell, until
the value of the formula in a1 is sent to a2.

how do I output result of formula to another cell?
 

If by "completely blank", you meant that the cell had to look empty...

You could use a formula in A2:

=if(somethingistrue,yourformula,"")

the "" will make the cell look blank--but the cell won't be empty--it'll contain
the formula.

Dave Peterson wrote:

Formulas can't do that. They can return values to the cell that holds them.

Francois wrote:

I would like to output the result of a formula to another cell (say formula
in a1 and result of a1's formula in a2)
I do not want a formula in a2, it must remain a completely blank cell, until
the value of the formula in a1 is sent to a2.

--

Dave Peterson

--

Dave Peterson