Questions tagged [formulas]
Formulas used in spreadsheets edited by web applications like Excel Online, Google Sheets, among others.
1,767
questions
12
votes
5answers
59k views
Conditionally formatting a cell based on another cell's value in Google Spreadsheet
I did some searching on this and came across this post.
However, this solution uses an onEdit() trigger. I would like to see a solution that uses a formula approach, so in the OP's example from that ...
1
vote
2answers
998 views
How do I select Column1's value if an input value is between the integers in Columns2:3 for a range?
In a Google Sheets I have two tables:
Date BMI BMI Outcome
2011-06-21 22.1 ?
2011-06-22 21.8 ?
2011-06-23 21.5 ?
and
Name From To
Severely underweight ...
7
votes
1answer
1k views
Google Forms erroneous deletes rows in second sheet
I created a form in Google Docs with quite some questions. For a good overview I created a second sheet to pick the important parts from the survey. There I'm also able to add extra columns to add ...
4
votes
4answers
5k views
Returning the SUM of a range of cells from user-input START to END
In Google Docs, I am trying to sum the values of selected rows in a table, from position START to END.
Imagining this sample data:
Index VALUE
1 300
2 400
3 750
4 850
5 ...
3
votes
2answers
5k views
Is there a way to search and replace a regular expression in Google Docs spreadsheets?
The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
4
votes
2answers
2k views
Google Spreadsheet conditional counting function
I am having trouble writing a function for this need (in Google spreadsheets):
I have 2 columns A and B.
I want to be able to get a percentage based on those two columns. I want to count the number ...
23
votes
3answers
9k views
Complete reference documentation for Google Spreadsheets formulae?
As a programmer, I find myself somewhat frustrated when trying to use Google Spreadsheets, because there seems to be no definitive description of the syntax that I can use for formulae. For instance, ...
9
votes
3answers
22k views
Are Excel formulas and Google Spreadsheet formulas the same?
I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
4
votes
1answer
201 views
How do I use a computed range in formula?
I currently use this formula:
=sumif($E$2:$E$363,L3,$D$2:$D$363)
I'd like to change it to instead of having the $D$363 hard coded, that it pick up the "363" part from another cell that I specify. ...
4
votes
1answer
1k views
What formula would I use to calculate monthly cost?
I'm trying to make a Google Sheets that will list my total expenditures in the form of recurring fees/subscriptions. I've successfully enabled the basic 'SUM=(C2:C24)', but I would like to add a ...
5
votes
1answer
2k views
How do I reference existing formulas from custom formulas in Google Spreadsheet Scripts?
I want something essentially like this:
function contains(arg1, arg2) {
return NOT(ISERROR(search(arg1, arg2)));
}
But NOT and ISERROR are undefined even though using =ISERROR(...) works in the ...
2
votes
1answer
4k views
Validation based on multiple sheets
I have two sheets that each contain a column of data that I would like combined and used as a validation list for a column in another sheet.
What would the formula look like for this?
2
votes
2answers
40k views
Google Spreadsheet formula, MINUS?
I have a spreadsheet with 3 columns:
| ITEM | COST | SUBTOTAL |
Subtotal, for example, is 1000 to start, like:
--------------------------
| ITEM | COST | SUBTOTAL |
--------------------------
| ...
1
vote
1answer
11k views
Take SUM of colored cells in a column in Google Spreadsheets?
I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background.
Is it possible to create a ...
57
votes
6answers
132k views
ISBLANK() function
Is there any way I can check whether a cell is empty?
There is a function ISBLANK() but it returns false when there's a formula in a cell even thought the formula doesn't return anything (or an empty ...
