how to put a formula in one cell and the result in a another cell

Not possible, a formula can only yield the result in the same cell that
holds the formula, you can use VBA to get this done however

--
Regards,

Peo Sjoblom

(No private emails please)


"mark" wrote in message
...
how to put a formula in one cell and the result in a another cell

mark

You cannot. Formulas can only return results to the cell in which they are
written.

You must have a formula also in the cell in which you would like to see the
result.

Something like =A1 where A1 is the cell with original formula.

OR skip the A1 part and write your formula in the results-to-be-seen cell.


Gord Dibben Excel MVP

On Sun, 7 Aug 2005 11:40:01 -0700, "mark"
wrote:

how to put a formula in one cell and the result in a another cell

"mark
Guest Posts: n/a

how to put a formula in one cell and the result in a another cell

--------------------------------------------------------------------------------

how to put a formula in one cell and the result in a another cell"



Mark, what you could do is to place a link in the other cell to display
the formula results from the cell which happens to have the
formula...eg. if A1 has the formula and displays the result but u want
it to appear in B1, then u just put "=A1" in B1...also if u dont want
to display A1, u may change its font color and make it invisible and
protect it so that no one my inadvertently delete it...

hope this helps...

Martin


--
R32Chaos
------------------------------------------------------------------------
R32Chaos's Profile: http://www.excelforum.com/member.php...o&userid=26001
View this thread: http://www.excelforum.com/showthread...hreadid=393700

If your goal is to see both the formula and the result at the same time, then
do as follows:

Enter the formula normally in the cell to display the result of the
calculation.
Enter the formula without the leading "=" to display the details of the
calculation in another cell.
--
Gary's Student


"mark" wrote:

how to put a formula in one cell and the result in a another cell

Hi Mark,
You can't, as already indicated but you can document the formula
used in another cell see GetFormula macro in
http://www.mvps.org/dmcritchie/excel...htm#getformula

You can also do the opposite, but I would not recommend that, because
with GetFormula you are simply reporting on a working formula.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mark" wrote in message ...
how to put a formula in one cell and the result in a another cell