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.

JC

Just refer to the cell A in your cell B formula.

In A1 you have =12*4 for a return of 48

In B1 enter =A1*2 for a return of 96


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:31:10 -0800, "JC" wrote:

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.

Hi Gord:
Thank you for the response. I also discovered that I was in a circular
loop between two formulas. The solution was to take the absolute value of the
first function's result and apply that as the argument to the second
function. That avoided the multiplying and dividing by the same number in the
prior loop.

JC

"Gord Dibben" wrote:

JC

Just refer to the cell A in your cell B formula.

In A1 you have =12*4 for a return of 48

In B1 enter =A1*2 for a return of 96


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:31:10 -0800, "JC" wrote:

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.