Questions tagged [formulas]

Formulas used in spreadsheets edited by web applications like Excel Online, Google Sheets, among others.

Filter by
Sorted by
Tagged with
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 ...

1
32 33 34 35
36