google-sheetssumgoogle-sheets-formulamultiplicationgoogle-query-language

Evaluate a Google Sheets math expression with formula


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)


Solution

  • try:

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

    enter image description here