MICROSOFT EXCELL

[thame]

Set up a basic spreadsheet with the =IF fomula on several lines. The problem is that as i enter numbers all the cells are recalculated. I know I can do it manually through options or shut it off entirely. I want to know how to set this up so once it calculates a cell it doesnt change when you enter numbers in other cells.

[Comp Guy]

Could you be a little more clear? I didn't quite understand what you were saying. Or maybe give an example or something....

[soybean]

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?