I have an excel document that I plan to save as a template to distribute to multiple team members. I'm having a problem protecting a formula inside of a cell. Here's the story:
The cell has a formula in it, but if you type a number in the cell and it's incorrect, when you delete the incorrect entry, it also deletes the formula. How can I embed a formula into a cell so that it stays with a cell no matter what as long is the sheet is protected? Please help. This is driving me nuts. Thank you.
The cell has a formula in it, but if you type a number in the cell and it's incorrect, when you delete the incorrect entry, it also deletes the formula. How can I embed a formula into a cell so that it stays with a cell no matter what as long is the sheet is protected? Please help. This is driving me nuts. Thank you.