Avoid circular reference in Excel The Next CEO of Stack OverflowHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Return empty cell from formula in ExcelShortcut to Apply a Formula to an Entire Column in ExcelIs it possible to force Excel recognize UTF-8 CSV files automatically?How to avoid using Select in Excel VBAInconsistent results in iterative calculation of circular reference in Excel 2010Excel - Stop Calculation on Opening to prevent circular referenceExcel circular reference with six simple formulasHow to remove circularities in Excel with a UDFR solving circular reference
Does soap repel water?
Why is information "lost" when it got into a black hole?
Proper way to express "He disappeared them"
Why the difference in type-inference over the as-pattern in two similar function definitions?
Make solar eclipses exceedingly rare, but still have new moons
Is there a difference between "Fahrstuhl" and "Aufzug"
Why does the flight controls check come before arming the autobrake on the A320?
Solving system of ODEs with extra parameter
Why this way of making earth uninhabitable in Interstellar?
Find non-case sensitive string in a mixed list of elements?
Why didn't Khan get resurrected in the Genesis Explosion?
Is a distribution that is normal, but highly skewed considered Gaussian?
Is there always a complete, orthogonal set of unitary matrices?
What flight has the highest ratio of time difference to flight time?
Chain wire methods together in Lightning Web Components
Can MTA send mail via a relay without being told so?
Unclear about dynamic binding
Writing differences on a blackboard
Why isn't the Mueller report being released completely and unredacted?
Is there a way to save my career from absolute disaster?
Does Germany produce more waste than the US?
The exact meaning of 'Mom made me a sandwich'
"misplaced omit" error when >centering columns
Do I need to write [sic] when a number is less than 10 but isn't written out?
Avoid circular reference in Excel
The Next CEO of Stack OverflowHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Return empty cell from formula in ExcelShortcut to Apply a Formula to an Entire Column in ExcelIs it possible to force Excel recognize UTF-8 CSV files automatically?How to avoid using Select in Excel VBAInconsistent results in iterative calculation of circular reference in Excel 2010Excel - Stop Calculation on Opening to prevent circular referenceExcel circular reference with six simple formulasHow to remove circularities in Excel with a UDFR solving circular reference
I would like to calculate price including risks. The problem is that I would like to avoid circular reference. Is there any way to avoid enabling "iterative calculation"?
Basically I need to calculate Price in B9 and it is =(B1+B4)/(1-B7)
where B4 is =B9*B2
Result with iterative calculation" enabled:
excel excel-formula formula
asked Mar 8 at 15:23
HiFoHiFo
244
add a comment |
I would like to calculate price including risks. The problem is that I would like to avoid circular reference. Is there any way to avoid enabling "iterative calculation"?
Basically I need to calculate Price in B9 and it is =(B1+B4)/(1-B7)
where B4 is =B9*B2
Result with iterative calculation" enabled:
excel excel-formula formula
asked Mar 8 at 15:23
HiFoHiFo
244
3
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
1
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.
– PeterT
Mar 8 at 16:01
add a comment |
I would like to calculate price including risks. The problem is that I would like to avoid circular reference. Is there any way to avoid enabling "iterative calculation"?
Basically I need to calculate Price in B9 and it is =(B1+B4)/(1-B7)
where B4 is =B9*B2
Result with iterative calculation" enabled:
excel excel-formula formula
asked Mar 8 at 15:23
HiFoHiFo
244
I would like to calculate price including risks. The problem is that I would like to avoid circular reference. Is there any way to avoid enabling "iterative calculation"?
Basically I need to calculate Price in B9 and it is =(B1+B4)/(1-B7)
where B4 is =B9*B2
Result with iterative calculation" enabled:
excel excel-formula formula
excel excel-formula formula
asked Mar 8 at 15:23
HiFoHiFo
244
asked Mar 8 at 15:23
HiFoHiFo
244
asked Mar 8 at 15:23
HiFoHiFo
244
asked Mar 8 at 15:23
HiFoHiFo
244
asked Mar 8 at 15:23
HiFoHiFo
244
244
3
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
1
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.
– PeterT
Mar 8 at 16:01
add a comment |
3
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
1
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.
– PeterT
Mar 8 at 16:01
3
3
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
1
1
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4
=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.– PeterT
Mar 8 at 16:01
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4
=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.– PeterT
Mar 8 at 16:01
add a comment |
1 Answer
1
active
oldest
votes
No matter the economical method you're using to calculate the risk (I'm not an economist), without the help of the Solver or VBA, the only way to do this is constructing an iterations table. The more expanded the table is, the more exact the solution will be...
Just place:
On cell D5: =($A2+D4)/(1-$A6)
On cell E4: =$A4*D5
and drag the formulas to the end of the table (horizontally).
answered Mar 8 at 16:11
PsplPspl
934417
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55066234%2favoid-circular-reference-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
No matter the economical method you're using to calculate the risk (I'm not an economist), without the help of the Solver or VBA, the only way to do this is constructing an iterations table. The more expanded the table is, the more exact the solution will be...
Just place:
On cell D5: =($A2+D4)/(1-$A6)
On cell E4: =$A4*D5
and drag the formulas to the end of the table (horizontally).
answered Mar 8 at 16:11
PsplPspl
934417
add a comment |
No matter the economical method you're using to calculate the risk (I'm not an economist), without the help of the Solver or VBA, the only way to do this is constructing an iterations table. The more expanded the table is, the more exact the solution will be...
Just place:
On cell D5: =($A2+D4)/(1-$A6)
On cell E4: =$A4*D5
and drag the formulas to the end of the table (horizontally).
answered Mar 8 at 16:11
PsplPspl
934417
add a comment |
No matter the economical method you're using to calculate the risk (I'm not an economist), without the help of the Solver or VBA, the only way to do this is constructing an iterations table. The more expanded the table is, the more exact the solution will be...
Just place:
On cell D5: =($A2+D4)/(1-$A6)
On cell E4: =$A4*D5
and drag the formulas to the end of the table (horizontally).
answered Mar 8 at 16:11
PsplPspl
934417
No matter the economical method you're using to calculate the risk (I'm not an economist), without the help of the Solver or VBA, the only way to do this is constructing an iterations table. The more expanded the table is, the more exact the solution will be...
Just place:
On cell D5: =($A2+D4)/(1-$A6)
On cell E4: =$A4*D5
and drag the formulas to the end of the table (horizontally).
answered Mar 8 at 16:11
PsplPspl
934417
answered Mar 8 at 16:11
PsplPspl
934417
answered Mar 8 at 16:11
PsplPspl
934417
answered Mar 8 at 16:11
PsplPspl
934417
934417
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55066234%2favoid-circular-reference-in-excel%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
Short of using vba or the solver, there is no method to do this without circular references.
– Scott Craner
Mar 8 at 15:31
Solver is not an option because installation of plugins is not allowed. What could be VBA solution?
– HiFo
Mar 8 at 15:38
1
Your logic in calculating risk is incorrect. Risk cost calculations are generally calculated directly from costs before sales margins are added. If your formula in B4
=B1*B2, the price is calculated correctly. Your total price comes out to be $1,262.50. Anytime you run into a circular reference situation, it's your calculation logic that's off, not the formulas.– PeterT
Mar 8 at 16:01