Joseph, the iterations you suggest are one way to do this. BUT, when I see
one of these circular references and I know I'm not iterating my way to an
approximate solution, I have to think--Why did this circular reference
occur? In the case of PMT and the other loan calculations it's because I
have a formula that has three values and I'm trying to calculate one given
the other two. Is this your case?

Mark

----- Original Message -----
From: "Joseph Hagerty" <joeh@t...>
To: "professional vb" <pro_vb@p...>
Cc: "'chris'" <chris@m...>
Sent: Wednesday, January 29, 2003 7:56 PM
Subject: [pro_vb] Circular Reference Part 2


> I have a problem I am having to solve in VB.
>
> I am using the PMT functions for some variables.  But the variables are
> in a three way loop:
>
> Basically:
>
> A = B+D+E+F
> B = Function(C)
> C = A * 3
>