Permanent formula in cell

All,

Is it possible to make a formula permanent in a cell. Even when the cell is filled it and then the data again removed?

Example.
The below formula is written in C12 looking in C11.

Please Login or Register  to view this content.

And now, The cell C12 will be filled in with than normally you will 'overwrite' the formula in C12.
Is there a way, that if I delete the 'value' that is filled in, I get the "formula" back in. (without having to copy paste the formula).
Reason why? this sheet will be used by others who aren't really advanced in excel.
(without macros if possible).

-=CWever=-

The short answer is no. If you enter data into C12 or delete it, then the formula is overwritten.

You could protect the cell so the formula could not be overwritten, but that would mean that the sheet has to be protected, so you would have to unprotect the other cells where you expect the Users to enter data.

Hope this helps.

Pete

Originally Posted by Pete_UK

The short answer is no. If you enter data into C12 or delete it, then the formula is overwritten.

You could protect the cell so the formula could not be overwritten, but that would mean that the sheet has to be protected, so you would have to unprotect the other cells where you expect the Users to enter data.

Hope this helps.

Pete

Arhghg, I was hoping that it is not so.
thanks for clearing this up for me.

Well, it might not be what you wanted to hear, but if that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete

You could put the formula in C13
=IF(and(C11="YES" ; c12=""), "Please Fill in C12" ; "")

or format the cell with and(C11="YES" ; c12="") as the conditional format and shade the cell when it needs to be completed

Originally Posted by davsth

You could put the formula in C13
=IF(and(C11="YES" ; c12=""), "Please Fill in C12" ; "")

or format the cell with and(C11="YES" ; c12="") as the conditional format and shade the cell when it needs to be completed

Thanks,

I have done with a continuous macro. However, I will check if this formula also works. using a help cell also works. thanks.