| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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) |
|
#2
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
| How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) | |||
| How can I get a total across multiple spreadsheets? | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
