Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

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.


  • EVAL("1 + 2") returns 3.
  • EVAL(CONCAT("cos(","3.141592654",")")) returns -1.
  • EVAL("1/0",TRUE) returns "1/0 ➜ Division by 0"


EVAL(  ,  

See also