Identical Formulas from Identical Data Sets Return Different Results

Hello All,

I can not figure out why Cells A100 and A202 should derive the same value but do not even if you type in the same values from Row 101 into Row 203. The sample spreadsheet is attached.

Thank you!

Patrick

Hi mehmetcik,

Appreciate your response! However I am not following your solution. I insert 2 rows to move the formula from Row 202 to Row 204
and the result did not change? What am I not understanding?

Thanks Again,

Patrick

mehmetcik,

That worked with a slight modification. I added the 2 rows further up the sheet so that both sections had identical spacing and
then just copied the formula in A100 to A202 (now A204 w/ the extra 2 lines) and it got within .10 and that is close enough for my needs.

Thanks again for all your help.

Patrick