I have some formulas that should be calculated at the same time to force the output to be 0.
So it should be repeated as long as it’s not 0.
Here’s an exemple:
|Month||Quantity||Quantity used||Data||target||Calculated quantity||Number1||Number2||Extra|
|1||2||2||1||3||quantity+ Data = 2+1||calculated quantity - target = 2+1 - 3|
|2||3||Calculated quantity month 1 + Quantity = 2+1+3||calculated data to have extra=0||2||quantity+ Data||calculated quantity - target|
|4||4||calculated quantity - target|
|5||3||calculated quantity - target|
so for missing values in Data columns, the formula is repeated till the extra column = 0
and “quantity calculated” & “quantity used” are updated at the same time.
for the “quantity calculated” i’ve already used a loop but as long as data has missing values it doesnt work.
Can anyone help me with that?