Evaluate a Google Sheets math expression with formula

Question

I have some strings inside Google Sheets, containing simple arithmetic expressions:

Is there a way to evaluate these expressions without the need for writing a script? (i.e. formula only)

score 2 · Accepted Answer · answered Apr 28 '22 at 18:23

2

try:

=INDEX(QUERY(; "select "&A6); 2)

answered Apr 28 '22 at 18:23

player0

1

Oh, wow, so this is essentially a built-in expression evaluator? I'll have to keep that in mind. – General Grievance Apr 29 '22 at 02:13

1 Answers1