J
Jollymon
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.
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.