set formula in one cell calculate in other

**aleksmkd** · 04-21-2014, 03:28 PM

Hi friends and helpers,

I cant figure out how to make a calculation of a formula thats been set up in different cell.
Example:
There is a calculation in A1 2*0.3+2*0.4+5*0.6 that i want it visible and possible to intervene in it.
Without retyping the formula i want it calculated in cell D1.

And it would be great if the formula set up in D1 could work with drag for the cells beneath, such as D2 for A2, D3 for A3....

thanks a lot,
youll make life more bearable

here the attachment

Formula.xlsx

**Sam Capricci** · 04-21-2014, 03:34 PM

So to clarify, you want 2*0.3+2*0.4+5*0.6 to stay as is in A1 but in D1 you want the formula to actually work and return the value 4.4, is that correct?

**aleksmkd** · 04-21-2014, 03:39 PM

And to be able to drag the "formula" in D1 to D2.... :p

thanks Sambo

**aleksmkd** · 04-22-2014, 03:05 PM

Hi everyone.

Do You think its possible to do in Excel this thing with the equations?
Sambo Kid understood very well what is my problem... I hope there is a solution...

Thank You all

**Sam Capricci** · 04-23-2014, 07:10 AM

I tried for about an hour to try to insert an equal sign in front of the cell using different formulas with left and mid and substitute many other combinations but to no success. I assume you also want to keep the original text equation in col A but want the actual answer in col C.
You may need VBA for the solution.

**zbor** · 04-23-2014, 07:28 AM

Here, try this:

Please Login or Register  to view this content.

use function as

Formula:

Please Login or Register  to view this content.

where A6 is for example your cell

**ragulduy** · 04-23-2014, 07:42 AM

You can also use evaluate as a named range instead of vba, for example, in your example, add a named range called "evaluate_formula" and give it the formula:
=EVALUATE(A1:A3)
then in D1 type:
=calculate_me
and copy down.

example is attached