"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