dependency issue, need workaround

[fanfaanfann]

Hi everyone,

My formula has dependency issue but somewhat the value need to be changed depending out the output

On sheet 2 -- table organic -- F14 is where the error lies

On sheet 2 -- table index: this is where the assumption of rising cost based on certain number of app install cumulative (sheet 1 -- column P)

Is there any solution on this?

Warm regards,
Fanie

[JeteMc]

The issue is with column K in sheet 1 which gets the value from column F sheet 2. The value in column K (sheet 1) is then used as part of the calculation for column P (sheet 1) which in turn is referenced by the formula in column F sheet 2.
I feel that this is more of an issue with the underlying logic of calculating the "Index cost Adnetwork" than with an Excel function/formula.
I don't understand the underlying logic well enough to help further, perhaps if you provide details we could figure it out.
Let us know if you have any questions.