Forum Discussion

hugovanleeuwen's avatar
hugovanleeuwen
Copper Contributor
Jul 08, 2020

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...
excel
Formulas and Functions
hugovanleeuwen's avatar
hugovanleeuwen
Copper Contributor
Jul 09, 2020

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

Resources