Cell formula protection

[Guest]

Is it possible to be able to protect a cell formula, but allow information to
be entered or deleted without the formula being deleted as well?

 

[Dave Peterson]

A cell can contain a formula or a value--not both (which should be used???).

But...

How about using a couple of helper cells?

Use A3 for the formula
Use B3 for the user input
Use C3 to determine which should be used:

=if(b3="",a3,b3)

 

[Trevor Shuttleworth]

No

a cell can contain one thing only which could be static data, like a number
or a name, or a formula, or a link to another cell (which I guess is a
formula)

You enter something in the cell, it overwrites whatever was there.

Regards

Trevor