I am working on an accounting in excel assignment dealing with bond amortization. The book says to use if statements on the payment and amortization and the interest and calculated by subtracting the two. I need to subtract the amortization from the carrying value of the bond but the amorization is an if statement and causes an circular reference. Because the steps in the textbook require the if statements i cant remove them to fix the circular reference. Is changing the iterations the only way to allow me too add?