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

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob" schrieb im Newsbeitrag
...
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?