conditional formula

[trevor]

hi all,

Ok this is my problem:

I have a value in one cell (A) which i am trying to replicate in another
cell(C). This is done using a formula in cell(C) which manipulates a value in
a third cell (B). I want to be able to write a function in cell (B) such that
its value which will then be used in the formula in cell(C) will ultimately
result in cell(C) equaling cell(A).

hope ye understand the explanation!

thanks!

 

[David Biddulph]

If you tell us what the formula is in cell C, then we might have more chance
of telling you what should be in cell B.

For example, if cell C1 says =2*B1, then the formula in B1 could be =A1/2
or =A1*0.5
As another example, if the formula in C2 says =SQRT(B2), then the formula in
B2 could be =A2^2 or =A2*A2 or =POWER(A2,2)