How do I create a formula that has circular conditions?

R

R Levin

I need to calculate the amount of a loan that rolls up interest and fees.
The fees are a percentage of the total loan. As the loan size changes the
fees change this keeps going round and round.
 
R

Raffael

All you gotta do is select the "iteration" option on Tools > Options >
Calculation tab.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

APR Fee Calculation 1
How do I create the formula for this calculation? 1
Financial Loan calc including monthly fees 6
Excel formula 5
Variable interest rate loan calculations- PLEASE HELP!!! 1
Calculation based on year of entry 1
Calculating interest due on late loan payments 1
How can I copy data produced by a formula, not the formula? 2

Top