How do I create a formula that has circular conditions?
 

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.

How do I create a formula that has circular conditions?
 

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


"R Levin" wrote
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.