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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
IF statement with 2 logicals 1
Calculation using IF 6
Calculation using IF 1
Nesting IF to correct #VALUE! Error Message 2
Conditional formatting referencing multiple cells. 3
Excel - Wich Function should I use? 1

Top