Locking a cell with a formula BUT.....

[Bob]

Is there a means of locking a formula within a cell but,
if another cells sum is not equal to 0 (zero) allow then a
a manual input value (in the cell with the locked formula)
but without deleting that formula?

 

[Frank Kabel]

Hi
AFAIK this not possible as a cell can only have a formula OR a manual
entry

 

[Rob van Gelder]

You want a formula *and* a value within the same cell?
It can only be one or the other, not both.

 

[Dave Peterson]

Sometimes when I want to get user input to allow overriding of a calculated
value, I'll use a couple of helper columns.

Say column A contains the formula (locked and not changeable)
Column B can contain the manual override (if necessary)
Column C can contain a formula that decides which value to use:

=if(b1<>"",b1,a1)

Then I use column C for the rest of the calculations.