>But nothing stops you from inadvertently changing the formula in cell C100. I'm not sure how recent this feature is but excel will actually warn you in you ch

>But nothing stops you from inadvertently changing the formula in cell C100. I'm not sure how recent this feature is but excel will actually warn you in you change a formula in the middle of a series of cells that all use the same formula. I was getting "inconsistent formaula" warnings just yesterday when I was trying to make a spreadsheet.