If someone could help with my issue, it would be great!

I am trying to make a custom amortization table using the one that microsoft
has a teplate for.

I would like to take a calculated value, subtract the supplied for "total
interest" and project that value into the supplied "loan amount".

The problem I am having is that when I try to do this, I get a circular
referance error. How can I correct this without having to write the entire
table from scratch?

Thanks in advance,

Paul M