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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob" wrote in message
...
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?