Hard: Circular interest formula
Interest = Total−Principal while Total = Principal+Interest → circular Err:522. Fixed uses =B4*B5*B6 → 24000 (LibreOffice verified).
Interest आणि Total एकमेकांना संदर्भ — Err:522. Fixed =B4*B5*B6 → 24000.
Interest और Total एक-दूसरे को देखते हैं — Err:522। Fixed =B4*B5*B6 → 24000।
Why → What → How
Why: Circular refs freeze models and hide the real business formula.
What: Broken B7 Err:522. Fixed interest 24000.
How:
- Open sheet Loan.
- Find the circular pair.
- Replace Interest with P×r×t.
- Confirm 24000.
Ravindra Bagale’s Tip
Turn on circular iteration only for true feedback loops — not for simple interest.
Ravindra Bagale’s Tip – मराठी
साध्या interest साठी circular iteration चालू करू नका.
Ravindra Bagale’s Tip – हिंदी
साधारण interest के लिए circular iteration मत चालू करो।
Bugs explained (with mini examples)
Bug 1 — Mutual references
Bug 2 — Enable iteration as fake fix
Practice tasks (12)
- Task 1. What does LO show for broken interest?Hint: Err:522.
- Task 2. Write closed-form.Hint: =B4*B5*B6
- Task 3. Expected value?Hint: 24000.
- Task 4. Change years to 3 — fixed updates?Hint: Yes.
- Task 5. Interview sentence.Hint: Interest was circular.
- Task 6. Principal cell?Hint: B4.
- Task 7. Rate?Hint: 12%.
- Task 8. Why not iteration here?Hint: No feedback loop needed.
- Task 9. Trace dependents on B7.Hint: Formulas tab.
- Task 10. Document closed-form.Hint: A10.
- Task 11. Bonus: compound interest.Hint: Optional.
- Task 12. Save fixed.Hint: Yes.
In-browser formula check
Type the fixed formula you would put in the named cell. We check formula text — open the workbook for full recalculation.
Step-by-step solution (try first)
- Replace circular Interest with =B4*B5*B6.
- LO: Err:522 → 24000.
Quick quiz