Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a cell reference in a formula | Excel Worksheet Functions | |||
Locking cell to protect the formula | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
locking formula cell references | Excel Worksheet Functions | |||
Locking A Formula In A Cell | Excel Worksheet Functions |