Permanent formula in cell

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