• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Avoid Circular Reference

T

Thomas Kuriakose

Active Member
Respected Sirs,

Kindly check the attached file which has a circular reference in cell C4, C5 & C6.

kindly let me know whether we can change to mathematical expression to avoid the circular reference.

Thank you very much,

with regards,
thomas
 

Attachments

Hello Thomas,
You have a circular reference because, you need to arrive at "272566" by calculating a % of "272566". This is like a circle and thus this error.

You can solve this problem just like you solve linear equations.
 
Hi ,

If you can explain what exactly you wish to do , then it might be possible to use the Solver to get the output.

What is the starting point , what is the input data , and how is the output to be arrived at ?

Narayan
 
Respected Sir,

i copied the value from C29 - GT to show the required results for Cost a, b and c which is calculated based on GT.

Thanks,

with regards,
thomas
 
Hi ,

If we enter the values :

545.13 , 545.13 and 109.03

in the cells C4 , C5 and C6 , then C29 does not equal 2,72,566.

If we change C2 to 2,46,501 , only then does C29 equal 2,72,566.

Narayan
 
Respected Sir,

Thank you for this information.

In this case we cannot alter value of C2 as this is the fixed value provided.

But, I would like to know the process on how to arrive at value 2,46,501 in C2.

Thank you very much,

with regards,
thomas
 
Hi ,

In that case , out of all the inputs , can you indicate which are the ones which can be varied ?

Once we know this , the Solver can be used to arrive at the solution.

Narayan
 
Respected Sir,

This is perfect. Thank you so much for the solution provided.

Kindly explain the how we arrived at the result.

Thank you very much once again.

with regards,
thomas
 
Hi ,

It is entirely manual.

1. Change the selection in Excel Options to enable Iterative calculation.

2. Enter the data for the solver.

3. The Solver returns a solution which is only a half-way solution.

4. Instead of changing the Solver settings , I manually changed the % values till I got the desired output in C29.

Narayan
 
Respected Sir,

Thank you very much or this information.

So, if Iterative calculation is not enabled, this will not work right.

Sir, just out of my curiosity, can we change the mathematical equations to avoid enable of Iterations.

Thanks,

with regards,
thomas
 
You must log in or register to reply here.
Back
Top