I have an excel sheet which I need to run on Android. Only problem, I used VBA for the Evaluate Function and VBA does not work on Android Apps. I was searching for an alternative and came a round the function "VALUE()", I saw that a Cell with:
=VALUE(10 + 5 * 3)
Would return the correct result (25). Now what I would like to do is:
Where A2 is a text containing "10 + 5 * 3". But this returns "#VALUE!"
Is there a trick how i could use VALUE() to evaluate simple formulas?