Excel calculation in one cell result in another

Question

Hello I'm wondering is it possible to have the calculation in one cell and the result in another so that when the calculation is changed it automatically changes the result in the other cell.

E.g
A1 = (2*3*4)*5
B1 = Result of calculation

As mentioned, i would like it when the calculation is changed in the specific cell it will automatically adjust the result in the other cell.

Answer 1

That's not how Excel works. What you call a "calculation" is really just a mix of numbers and symbols, which Excel regards as text.

Instead of putting text with a mix of symbols and numbers into a cell, you'd typically enter the number values into individual cells, then enter a formula into the cell where you want to see the result. That formula will reference the input cells. Example below.

Now you can change the values in the columns A, B, C and D and the result in column F will re-calculate.

What you describe can be achieved with the help of a named formula that you insert with Formulas > Name Manager > New then enter this formula into the Refers to field

=EVALUATE(Sheet1!$A$1)

Then enter the named range into a cell like in this screenshot

But then again, if you enter a "calculation" like (2*3*4)*5 into a cell, you might as well put a = sign in front of it and there is your result.