Problem with a circular reference! Modifying the formula & the table to avoid it.

[Arty_1]

Hello!

I've encountered an issue concerned a circular reference.

There are two interrelated formulas which are extremely important to each other.

Would you be so kind as to help me with an advice?

is there a way how to modify the formulas to avoid the circular reference?

I've attached a xlxs file with more detailed description

Thanks in advance

A.L.

[Glenn Kennedy]

I'm confused... Does this help at all (G2):

Please Login or Register  to view this content.

[Arty_1]

Hi!

G2 is interrelated with D2 and vice versa.

I admit it would be worth it to try to figure out how to change the layout of the table to avoid the circular reference.