IF Statement....If False how ignore referenced cell

[Guest]

Hi,

Is there a way using a "IF" statement that when the statement is false it
ignores the cell it is writing to. For example: If(A1=1,B16,ignore)

When it looks at cell A1 it will write what is in cell B16 (let's say 7).

Next I want to change cell A1 to a 2 (because my value in B16 has changed),
which makes the original IF statement False and typically overwrites the
value in the cell with False, " " or "0". I would like it when FALSE, to
leave the value 7 and not overwrite it..

Hope this makes sense.

Any help would be greatly appreciated.

 

[Frank Kabel]

Hi
this is not possible with formulas. It would require VBA (using an
event procedure)