Automatic Cell Conversion - Formula

New to this forum. Been playing around a lot with Excel and different aspects of it. But I don't have any one that I can work with about advancing what I already know. Hopefully this is a great place to do just that.

I have a cell that I want to enter a value in, and I want that same cell to automatically convert itself via a formula. I haven't had any success with this one.

=SQRT(I14^2+144)/12

I14 would be the cell that I need to input that value... and automatically convert to the rest of this formula.

Any help would be appreciated. Thank you.

You mean update the same cell with formula that the value is entered?

No that cannot be done, via formula. Cell must either be a constant (i.e. manually entered value) or a calculated value, it is mutually exclusive.

While, it is possible to update constant stored using VBA. I usually don't recommend this approach, as it won't allow for quick retracing of steps.

I'd simply use another cell to store formula (and it's result). Rather than updating original cell.

Hi canonjoe,

Could you please take a few minutes and update your thread title to something more descriptive to what you are asking. This is one of our forum rules. I tried to come up with a title, but not clear myself.

There is no "formula" way to do this. You can either have an entry in a cell OR a formula, you cant have both.

To do what you want, would require VBA