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)
--
David Biddulph


"trevor" wrote in message
...
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!