• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Use text from formula and evaluate the result

B

Bigjohn33

New Member
I have the following issue.

I am trying to input complex formulas, then auto calculate without copy and paste. For example in cell A1 i would input something like (6.55 + 5.88)*555.56+88*444. My goal is the result (which in this case is 45977.6108) to appear automatically in cell A2 without having to copy and paste. It would be even better it this was interactive, ie if I changed a value in the equation the result would change automatically. If I found a solution I would greatly speed up my work that has to do with quantity surveying. Thank you
 
You can do it, just takes some "sneakiness". We need to first define a Named Range. In 2003, go to Insert - Name - Define. In 2007+, go to Formulas - Define Name.

Give it a easy to remember name like "EvalCell". In the "refers to" box, write:

=EVALUATE($A$1)


Ok out.


Now, in your workbook, you can write this formula:

=EvalCell


and it will display the result of formula in A1.


Have lots of formulas? If so, we might be able to make our named range relative, rather than static like we started with. Let's say that you are inputting formulas into col A, and want results in col B. First, select B1, and then modify the named range to refer to:

=EVALUATE($A1)


Now, any cell that you write this formula in:

=EvalCell


will evaluate the text from col A from the same row that formula is in.
 
You must log in or register to reply here.
Back
Top