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:
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)
- Google Sheets IMPORTDATA for xlsx files
- Dynamic AND statements in google Sheets query
- Why can't I add parameters to my Google Script - Web App?
- Protect a range once all the words are created so noone can edit them
- How to return or parse chart data properly in React from google apps script?
- Can I alter the default data format in sheets for muli-select checkboxes in forms- or do I need to wrangle afterwards?
- Blood Sugar Chart for Two Diabetic Cats in Google Sheets
- How to convert a function cell into a string automaticly in google sheet
- How to create a dynamic list, based on checkboxes? [Google Sheets]
- Working Around Large Dataset that gives me 413 Error
- Sorting time ascending in Apps Script
- How can I export Google Sheets tabs to Excel from Apps Script using the Sheets Gid?
- Is there any way to skip particular words from translation in 'GoogleTranslate()' function in spreadsheets?
- Unique Filtered Data
- Copy one sheet from one spreadsheet to another spreadsheet with formatting
- GoogleSpreadsheet, VLOOKUP with an empty cell
- Is it possible to use a checkbox to filter results in Google Sheets?
- Get last column in Google Sheets API v4 in c#
- Using built-in spreadsheet functions in a script
- Use formula inside script
- SpreadsheetApp how to use variable inside formula
- Filter or Query or Index? Need to return a list of names from people who have a specific value in a cell
- onEdit() e.source returning first sheet in spreadsheet, not edited sheet
- Sort entire sheet in descending order
- How can I get my scatter plot to plot row 1 in X axis and rows 2 & 3 in Y axis
- Generate unique random numbers in Google Sheets
- Is there a way to determine when a spreadsheet is done calculating?
- Formula with custom script doesn't update in Google Spreadsheet
- Script that puts google sheet to calendar duplicates events every time it is run
- I have a dataset of team members reserving one ( or more) of five rooms. I need a function that can populate a Schedule Sheet dynamically