EVALUATEFUNCTION(expression, variable, value)

Google Apps Script Custom Formula that evaluates a mathematical expression with a variable substituted by a given value.

Since Google Sheets doesn't have a built in formula for this so, I made one myself.

YouTube Shorts Demo

https://youtube.com/shorts/xIv6wPgIyZo?si=cgYEywZShYYc9FtW

EVALUATEFUNCTION() Demo

Syntax Errors return the entire string to be evaluated instead of the final result (Shown on the right).
EVALUATEFUNCTION("x^(2) + (8/3)*x - 20","x", 3)
EVALUATEFUNCTION("cos(x) - x","x", =PI()) Note: Trigonometric Functions evaluates to DEGREES by default, you can change it to RADIANS in the `Code.gs` Editor
EVALUATEFUNCTION("log(x) - 1/x","x", 3)
EVALUATEFUNCTION("log10(x) - 1/x","x", 3)

How to use?

• Just copy the entire Javascript code from EVALUATEFUNCTION.js and paste it into your own Google App Script Code.gs.
• Save

References

• Code inspired (mostly copied) from Code Explained's Video: https://www.youtube.com/watch?v=52GL_cfLBYs

Bugs?

• create an issue

Thank you.