Insert Row - Weird behavior?
Posted by Paul Hermans on November 21, 2001 11:32 AM
I have a simple spreadsheet with several rows of data in it.
For argument sake, say column A has numbers in it and Column B has a formula that looks like this:
and Column C has a formula that looks like this:
If I insert a row in the middle of a table, and then enter a number in column A suddenly the formula for column B appears but not the formula for column c.
My question is, WHY does the IF satement suddenly show up? After inserting the row, I checked to see if the formula was in the cell already, it wasn't....so I'm very confused.
I am using Office 2000 on Windows 2000.
Any ideas would be greatly appreciated.