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

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?

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

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?

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

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?

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

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.

Bob wrote:

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?

--

Dave Peterson