reiteration in excel

  • Thread starter Thread starter kc
  • Start date Start date
K

kc

Could anybody help?

Construction Cost (CC) = $100,000
Statutory Charges (SC) = (0.3% of Construction Cost + Professional Fees)
Professional Fees (PF) = (10% of Construction Cost + Statutory Charges)
Formula:
SC = (CC + PF) * 0.3%
PF = (CC + SC) * 10%
Problem :
SC & PF are not picked up automatically
 
hi,
try to set before using your constanta
PF = range("a1")
SC = Range("A2")
or something...
 
Your formulae create a circular reference, so you need to tell Excel that
this is deliberate, rather than a mistake.
Tools-->Options-->Calculate and check the Iteration box


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inter-dependency 1
Hide Subtotals in Pivot Table for Certain Columns 1
Puvot Refresh 2
Help with find 1
won't open file 15
Position Input data in Cash Flow table 2
Macro for searching out side excel?? 1
help to count easily 2

Back
Top