Forum Discussion
Formulas and functions
Hi Is there a way to calculate a value displayed in one cell in another cell ie: if I had a value of 3/10 expressed as text in one cell, is there a way to calculate this value as a decimal in ...
This is funny and crazy too.
Using FILTERXML() function you will return a matrix containing the numbers
=FILTERXML("<x><y>"&SUBSTITUTE(K4,"/","</y><y>")&"</y></x>","//y")
Then you just need to get the first element and divide by the last element
INDEX(PreviousFormula,1)/INDEX(PreviousFormula,2)
As it envolves a lot of effort, would be a good idea you use a more modern method like LET() function, so you can create a more elaborate example.