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
|