Hello,
Here is an example:
https://jsfiddle.net/obpLsg81/8/Last version is used for this example, however problem is present in previous versions, also.
Column 4 is calculated with JS Formula has to take a calculated value from column 3, but does not see it
Column 5 is same, but is calculated with Excel Formula and works fine.
That seems to be a problem of the fixed order/priority of calculation.
We are not confusing but combining both types of formulas, so this is an important bug in calculation.
Thank you in advance