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.