EVAL function
EVAL(expression[,showerror]) evaluates an expression. The expression must be a text string. If the optional boolean parameter showerror is TRUE, then some informational message will be displayed in case an error occurs.
You can construct a string and then pass it to the Eval function as if the string were an actual expression. The Eval function evaluates the string expression and returns its value.
Examples
- EVAL("1 + 2") returns 3.
- EVAL(CONCAT("cos(","3.141592654",")")) returns -1.
- EVAL("1/0",TRUE) returns "1/0 ➜ Division by 0"