View calculation and result simultaneously

J

johnnyefres

My question is simple:
Can I have the calculation and the result visible on the same sheet a
the same time?

What I'd like to see is:
5+2+7*(3+4,1) in cell A1 and
56,7 in cell A2 at the same time

Note that the formula in cell A1 can change at any time.
Ctrl +` works fine but I can't print everything on the same page usin
it.

Your help would be very much appreciated
 
F

Frank Kabel

Hi
you may use the following user defined function:
Public Function eval_it(eval_str)
eval_it = Application.Evaluate(eval_str)
End Function

use is in your example like
=eval_it("=" & A1)
 
C

Charles Williams

Probably better to use a UDF to show the formula rather than evaluate it:

Function ShowFormula(theRange As Range)
ShowFormula = theRange.FormulaLocal
End Function

But if you want to use an evaluate function I would recommend you use a more
robust version that works under more circumstances:
see http://www.decisionModels.com/calcsecretsh.htm

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
J

johnnyefres

It apears that your suggested solutions should work fine. My problem is
that I cannot implement them to my worksheet because I lack experience
for that. Please, try to be more explanative. How do I create a user
defined function? The best would be if someone could create it for me
in this file.
http://users.ntua.gr/iefre/Calculation_Formula.xls
Sorry to bother you guys. I'm trying to get into Excel, hoping I will
be able to help other people in the future!
 
J

johnnyefres

Thank you very much guys!
I just solved the problem
I'm mostly grateful.

The only software I could be of help with is Primavera Project Planne
P3. Should anyone have queries, I'd try to help
 
Top