Forum Discussion
hugovanleeuwen
Jul 08, 2020Copper Contributor
from Function results to "real" numbers to calculate
I have made a some nice excel sheets, but the problem is I can't calculate with the result of these functions Start value: '(−158|39) (imported from internet) First function: =LINKS($E4,VI...
hugovanleeuwen
Jul 09, 2020Copper Contributor
SergeiBaklan
I have found the solution. because every combination has an unique lenght I combined the functions have serveral times with =IF and =LENGHT now it's working without problems. thanks for your suggestion, it was helpfull to keep looking and trying different things.
Thanks,
Hugo
SergeiBaklan
Jul 09, 2020Diamond Contributor
Hugo, you are welcome