How do I not replace formula with calculated value.
 

I am trying to use the value of a cell in the formula of that cell to
calculate the value without replacing the formula.

How do I not replace formula with calculated value.
 

I don't follow you, can you elaborate more or better to show your example
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"vkj" wrote:

I am trying to use the value of a cell in the formula of that cell to
calculate the value without replacing the formula.

How do I not replace formula with calculated value.
 

It sounds like you're trying to create a circular reference!
Assume A1 = 5. If you were to write, in A1:
=A1*2
XL will yell at you for creating a circular reference, but you can choose to
switch to manual calculation, single iteration.
If you choose yes, A1 now equals 10. If you press F9 (to calculate) A1 will
display 20.

If this is not what you are trying to do, please provide a clearer example
(using cell references, not just saying "cell").
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"vkj" wrote:

I am trying to use the value of a cell in the formula of that cell to
calculate the value without replacing the formula.

How do I not replace formula with calculated value.
 

I don't understand your requirements.

A cell can hold a formula which returns a value.

Or a cell can contain a value only.

If you type a value into a cell with a formula, the formula will be
overwritten.

Show us an example of what you want to do.


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 11:26:04 -0700, vkj
wrote:

I am trying to use the value of a cell in the formula of that cell to
calculate the value without replacing the formula.