I’m not sure if I’m missing something obvious or if this isn’t a function, but I’d like to be able to solve a math equation, written in the form of say something like: 9+(5*2)/10-2 that has been entered into a table as text.

If I enter that into a formula directly, it renders the answer as 8. But if I have it entered into a cell of a table, all I can do is call up the row.column, and it displays “9+(5*2)/10-2”, but I can’t solve it

This came up when I was trying to make a calculator template I could paste into docs when convenient. Realized after I built it to do some basic functions that it would be very hard to render complex formulas like the eg above. But also that it would be fairly easy if I could just use the buttons to type into a cell and then another button to solve the equation when I’m done.

here’s the semi functioning calc I’ve built