Reply to thread

Message: [QUOTE="Charles H. Sampson, post: 7423175"] To absolutely nobody's amazement, the problem is mine. Here's a brief explanation. Elsewhere in this thread I gave a summary of the contents of the 17 cells in the sum. When I entered 54 into one of the blank cells, the value of the sum went up by exactly 100. I was interested in the effect this 54 would have in the sum, so I was staring intently at the cell containing the sum. What I didn't notice was that another value of the 17 also changed by, would you believe it, 46. (These are all figures that are carried to two decimal places.) I blame it on psychology. The change of an even 100 was so striking that I was transfixed by it. I think that if the change had been something like 89.21 I wouldn't have been in such a hurry to jump to the conclusion of an Excel problem. Maybe not. The only outstanding question now is: Why did I think I had verified the error using my calculator? My memory of exactly what I did with the calculator is gone, so I'm not going to pursue that. Again, many thanks to those elected to waste their time on what was obviously a mistake on my part from the very beginning. Charlie [/QUOTE]