The question doesn't make much sense. Obviously, if you use IF statements in cells and those IF statements refer to other cells and you change the contents of those other cells, then the content displayed in the cell(s) with the IF statement is going to change.
If you don't want this to happen, you need to answer a basic question. Why are you using IF statements?