How does one update and transfer values between cells and not the.

[JC]

I have a spreadsheet open that has several layers of formulas. I need to take
a result of a formula in cell A and use that in the argument of another
formula in cell B. Currently I have copied the contents of cell A to cell B
and so the prior formula not the result is in the cell and as such the new
argument can't update the changes to the value of cell B because between the
two formulas I am multiplying and dividing by the same number.

[AlfD]

Hi!

If you want B1 to pick up the result from A1, then put =A1 in B1.

Copying from A1 to B1 is Excel's job, here, not yours!

So if, for example A1 contains =x1*2 and B1 contains =A1-93, then your chain of formulae results in B1 showing the value of (x1*2)-93.

Is this what you are seeking or have I invented my own problem and missed yours?

Alf