spreadsheets, calculation

C

cooch

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)
 
J

JE McGimpsey

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.
 
Top