Forum Discussion
4lvis_bondarenko
Mar 03, 2021Copper Contributor
Formula help needed..
Hello! Im a little bit stuck here with this nested formula that doesn work for me. Here is what i am trying to do here: IF A=text1 then (B-C)*10 and IF A=text2 then (C-B)*10 Can anyone help...
- Mar 04, 2021
Instead of I:I please use I2:I10000, even better dynamic ranges, even more better transform range to table.
Same for each column in formula.
4lvis_bondarenko
Mar 04, 2021Copper Contributor
Riny_van_Eekelen This is the error that i get and error trace tool show where the fault is but i dont understand whats wrong with it.
SergeiBaklan
Mar 04, 2021Diamond Contributor
Instead of I:I please use I2:I10000, even better dynamic ranges, even more better transform range to table.
Same for each column in formula.
- 4lvis_bondarenkoMar 04, 2021Copper ContributorSorted. Thanks a lot mate.