spreadsheets, calculation
 

how do I get the answer of a calculation to goto a cell, if say A1+A2=answer
goto say F4, (F4 dosnt have a calculation in it)

You need to put the formula in F4:

=A1+A2


Formulae can't insert values in other cells. If you absolutely need
that, you can do it using VBA. Post back if that's required.

In article ,
"cooch" wrote:

how do I get the answer of a calculation to goto a cell, if say A1+A2=answer
goto say F4, (F4 dosnt have a calculation in it)