View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Raffael Raffael is offline
external usenet poster
 
Posts: 29
Default 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.