Is this the same file that has "an amount error after the calculations", per your posting at https://www.msofficeforums.com/excel...e-amounts.html ?

I was suggesting that the latter is due to rounding issues.

But circular references, be they on purpose or by accident, can cause all sorts of unexpected results.