as you can see I need the one to calculate the other one,
is this possible to do in JavaScript, because in .Net you have to calculate the one before the other?
Let’s replace the financeRate in the first line with the definition of it from the second.
capitalCost = capitalCost + tenantingCost + estimateCost;
Subtract capitalCost from both sides
capitalCost - capitalCost = tenantingCost + estimateCost;
and we end up with this:
tenantingCost + estimateCost = 0.
So the original formulas are only valid when the tenantingCost and the estimateCost precisely cancel each other out - which has me too thinking that the formulas are wrong.
Edit:
I see I repeated the same conclusion here as Jake. That’ll learn me to keep a thread open for an hour or so before replying to it.
Alright, let’s put it this way, I pose this math problem to you:
X + Y = 42.
Solve for X and Y.
If you assume the value of one, the value of the other becomes immediately apparent, but without more information all we can do is plot a linear graph.
Alright, let me walk you through what you seem to be explaining. I just tried this in excel:
A2=5000000
B2=1250000
C2=D2+A2
C2=C2+B2
In excel, this results in an error. If you try to resolve this on paper, you will see it is unresolvable to a single answer without defining at least one variable between capitalCost and financeRate. Variables cannot depend on each other in such a fashion.
Mathematically, your only option is plotting a graph. You have to fill in one of the blank variables to give your other one any meaning.
This isn’t a programming issue, it’s a mathematics problem.
If they have found a way to make this work the way it seems, send them to your nearest computing research center so they can take a look at the paradox-free undefined circular variable mathematics.
… oh, then I’ll finally be able to pull myself up by my bootstraps!
capitalCost = financeRate + estimateCost;
financeRate = capitalCost + tenantingCost;
Something has gone wrong in the maths here… big time.
Typically financeRate, estimateCost, capitalCost and tenantingCost are all positive. In the above situation, that is impossible (how could one get the other and add to it, whilst the other does the same!?)
If financeRate = capitalCost + tenantingCost, and capitalCost = financeRate + estimateCost, then financeRate = financeRate + estimateCost + tenantingCost, therefore estimateCost + tenantingCost = 0, therefore estimateCost and tenantingCost are equal but opposite. Obviously this cannot be the case.
That would be wise. If they have found a way to make this work the way it seems, send them to your nearest computing research center so they can take a look at the paradox-free undefined circular variable mathematics.
Good luck!
Again, for me this result is telling me exactly what I’d expect. I get what’s called a Circular Reference warning. I’ve included a screenshot to show you what the result is. If you’re not getting a warning like this, your workbook must have a special case for this scenario, because in math you cannot have variables that are determined by the answer they are meant to find. Input begets output, output does not alter input.