Formula required for caluculation

[prakash]

Dear Experts,

Need the below formulas in column B5 & B6
Where values in B1 to B4 is available as under



B1 772
B2 2
B3 32500
B4 210
B5 ???? (A6/100000) * A4
B6 ???? ((A3 - A5) / A1 ) * 100000

 

[prakash]

sorry wrongly mentioned as A instead of B

 

[Oaktree]

If B5 = (B6/100000)*B4
And B6 = ((B3 - B5)/B1)*100000

You'll get a circular reference error because B5 references B6 and B6 references B5.

Maybe there's a different way to calculate what you're after?

 

[prakash]

yes i am getting a circular refernce . But there will be an euqation at least trial and error methord to find out the values.

can you help me out here

 

[Oaktree]

It's unclear what you're trying to do.

"Trial and error method to find out the values" implies that there is one value/solution for the calculation you're trying to perform. But, because of the interdependent of B5 & B6, their values will depend on the starting values and number of iterations after which you stop.

Maybe the correct relationship/calculations for these two cells should be different from your initial post?