is there a vba function or excel formula to avoid circular reference error?

[outlawdevil]

I am trying to paydown loan balance $2 increment on loan balance of $14 if my checking account is greater than $2. I wanted to paid in full eventually so I keep reducing my loan balance if there is a payment. If I used both If & to validate condition statement in my formula, it runs in to cirular reference. Anyone knows if there is a better way to do this? Please see the attached image for example. Thanks.

 

[outlawdevil]

It would help to show how your checking account increases in value after you take money out.

Sure, added one column to replenish funds. As you can see Payment 7 overpaid 2 when pull down the formula.

 

[6StringJazzer]

Your original description said you wanted to make payments of $2 but this example shows payments #1, 6, and 7 are more than $2. Can you clarify how to determine the payment amount?

 

[outlawdevil]

Your original description said you wanted to make payments of $2 but this example shows payments #1, 6, and 7 are more than $2. Can you clarify how to determine the payment amount?

Sorry i changed the Payment amount to pay down faster given that I have $2 left in checking account. The rounding formula can give me the maximum drawdown while maintaining $2 in checking acct balance.

 

[outlawdevil]

Just to quick update, I figure out a away to do this with MaxIf and netting against the loan balance. I can close this now. Thanks for all your help.