#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KC KC is offline
external usenet poster
 
Posts: 107
Default inter-dependency

Dear sir

Construction Costs (CC) $100,000
Statutory Charges (SC) 0.300% $336
Professional Fees (PF) 12.00% $12,040

Problem SC depends on CC & PF, but PF depends on CC & SC

What is the best way to get a final answer for both SC & PF?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 418
Default inter-dependency

"kc" wrote:
Construction Costs (CC) $100,000
Statutory Charges (SC) 0.300% $336
Professional Fees (PF) 12.00% $12,040

Problem SC depends on CC & PF, but PF depends on CC & SC
What is the best way to get a final answer for both SC & PF?


You should post your formulas, at least in abstract terms. From the numbers
above, I infer:

SC = (CC + PF)*SCrate (SCrate = 0.3%)

PF = (CC + SC)*PFrate (PFrate = 12%)

I suspect that you misunderstand your own requirements. The real world does
not normally create circular dependencies like that.

I believe there simply is no solution to that pair of formulas in the real
world -- unless the __real__ problem is to derive SCrate and/or PFrate such
that those relationships are true.

Even that seems hard. But if that's the case, please clarify the problem
you are trying to solve. That is, which rate or rates are you trying to
solve for; and if both, what are the constraints.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dependency changes after row insert John Excel Discussion (Misc queries) 1 January 14th 08 10:22 AM
how to build Dependency Trees in Excel [email protected] Excel Discussion (Misc queries) 3 January 8th 07 08:07 AM
Drop down dependency stuff Pasty Excel Worksheet Functions 2 November 13th 06 10:13 AM
Need to output the dependency tree for formulas Adhiza Excel Discussion (Misc queries) 0 October 13th 06 04:51 PM
[email protected] Ron de Bruin Excel Discussion (Misc queries) 1 July 21st 05 01:07 PM


All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"