hi,
I use excel everyday ,but there is a problem that puzzled me for a long
time.when I input a formula ,for example,in one cell I input
(12.36+2.36)*25+36,and I want to obtain the result of the formula in
another cell,what should I do.I always get (12.36+2.36)*25+36 itself instead
of the result 404.maybe someone would tell me sth helpful,or would you give
some hints in vba.I think confirmedly it is unnecessary to input the formula
once again to get the result.though I havent solve the issue.
regards.
Thank you.

It would be much better to code the actual formula as a formula,
that way you know that you are working with a valid formula,
that does not have errors and that gets adjusted when you
insert/delete rows/columns. Then in your other cell use
a function to obtain the formula from the cell with the formula.
This way you are not prone to inevitable errors doing it the
other way around.

=GetFormula(D1)
=personal.xls!GetFormula(D1)

More information in
http://www.mvps.org/dmcritchie/excel/formula.htm

David McRitchie, Microsoft MVP, Excel


"youngman" wrote ...
=I input a formula ,for example,in one cell I input
(12.36+2.36)*25+36,and I want to obtain the result of the formula in
another cell,what should I do.