change excel cell without changing its formula

Question

greetings.
How I cando to change the value of a cell in excel without losing the formula associated to that cell?

thx.

Answer 1

Is is feasible to change the formula? If not, you're probably out of luck, but if you explain in more detail what you want to accomplish, somebody may come up with a workaround.

---

Regards, Hans Vogelaar

Answer 2

thanksfor answering

the explanation is this, I have cells which are calculated by formula, but at some point need to modify and put any value in some cells, but doing this, the formula for that cell disappears, and only I have the courage to enter.
I want the value you enter appears in the cell but the formula still remains.

The thing I have other cells that are calculated from these other cells that I want to modify.
And obviously if the calculation in the wake of the entered values, vary the final result.
I hope I was clear.
Thank you.

Answer 3

I'm afraid that is not possible - if you enter a value in a cell, you overwrite the formula. You could perhaps use the following instead.

Let's say the cell with the formula is D2. If you want to override the result of the formula, enter the desired value in another cell, say E2.

In a third cell, for example F2, enter a formula that will return the result of the formula in D2 if E2 is blank, otherwise the value of E2:

=IF(E2="",D2,E2)

You can then use F2 instead of D2 in other formulas.

---

Regards, Hans Vogelaar

Answer 4

thanks a lot.