Evaluate a Google Sheets math expression with formula

user_4413235 0
Viewed 66

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

enter image description here

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

google-query-language google-sheets-formula multiplication google-sheets
1 Answers

try:

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

enter image description here

user_56326290
Related