Go to: Tools | Options | Calculations | Iteration and make sure the box is
checked. Read up on this parameter in the Help file to adjust the number of
iterations to one that fits your needs.

Good Luck!!
--
Thx
MSweetG222



"jhahes" wrote:


I have the following

A1 = Closing Costs
A2 = 1st Mortgage
A3 = Debt Consolidation
A4 = Loan Amount (Sum of first 3 values)

A1(Closing Costs) is dependent on A4 for its calculations...So I get a
circular referencing.....I tried to build a function...but when I put
=ClosingCosts in Cell A1, I get a REF error in A1 and in A4...Below is
my function

Function ClosingCosts(loanAmount)
If loanAmount < 100000 Then
ClosingCosts = loanAmount * 0.045
ElseIf loanAmount = 100000 And loanAmount < 180000 Then
ClosingCosts = loanAmount * 0.035
Else
ClosingCosts = loanAmount * 0.03
End If
End Function

could someone please help with any direction...
thank you


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=570227