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?

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)

Boenerge wrote:
>
> 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

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


"Boenerge" <(E-Mail Removed)> wrote in message
news:FAA1CA8A-1966-4D3A-A8CA-(E-Mail Removed)...
> 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?