G Guest Dec 26, 2004 #1 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)
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 Dec 26, 2004 #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.
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.
