Forum Discussion
Formulas and functions
This is very much 'for interest' at the moment because it relies upon functionality currently only available under Microsoft 365 insider beta channel. The formula is an alternative form of that presented by HansVogelaar .
I created a defined name EVALUATEλ (I use the Greek letter λ from Insert/Symbol merely as a reminder as to the nature of the formula the name refers to) defined by
= LAMBDA(expr, EVALUATE(expr))The worksheet formula is then
= EVALUATEλ(expression)where 'expression' is currently an array of fractions as text but could be any other formula in text form, such as 'EXP(1)' which would evaluate to the math constant e.
Note: EVALUATE is an old XLM macro command and there is no assurance that it will be supported intefinitely.
To make it dynamic considering the values are on left column
=EVALUATE(INDIRECT(ADDRESS(ROW(),COLUMN()-1)))Find attachment
