"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