formula Questions
4
Solved
I have 3 rows in my Google sheet, that is stock, price, and total. so, I just use "multiple" formula for stock and price then put the value into the total row. but I don't want total row get an upd...
Assume asked 9/6, 2019 at 13:29
6
In column A I have list of different names. In column B, I have values either 0 or 1.
I want to get a count of all the unique names from column A which have 1 in column B.
Using below array formu...
Pediment asked 11/4, 2013 at 8:39
4
I need a formula that will look up a value in a 2-dimensional range and return the coordinates or cell address of the matching cell. For example:
R A B C
1 John Matt Pete
2 Sara Bret Chad
3 Lila ...
Phane asked 3/4, 2014 at 2:54
6
Solved
In the new Google sheets there's a way of formatting a number as a duration. Format -> Number -> Duration.
1 is formatted as 24:00:00
1.2 is formatted as 28:48:00
1.5 is formatted as 36:00:00
0.0...
Annemarie asked 7/9, 2014 at 12:42
4
Solved
I have a calculation which I am unable to crack.
Lets say my Cost Price is 300. I want to sell the item at No Profit or No Loss. My total commission/expenses will be 30%. So it means i need to sel...
Strawworm asked 19/12, 2017 at 20:25
3
Solved
Are there any easy ways to convert mathematical formulas to Python code?
Perhaps translators, web reference, specific book chapters, anything ~
For regular expressions there are programs such as K...
2
Solved
Instead of something like lm(bp~height+age, data=mydata) I would like to specify the columns by number, not name.
I tried lm(mydata[[1]]~mydata[[2]]+mydata[[3]]) but the problem with this is that,...
8
Solved
How to calculate the number of working days between two dates in JavaScript using moment.js. I have a working formula that calculate these days, but the formula does not satisfies all conditions:
...
Choosey asked 10/2, 2015 at 6:1
6
I was wondering if there is anyway to return the name of the table using a formula?
I was working on a way to break down a few thousand addresses into there perspective column of information. ie.....
21
Solved
I am trying to calculate a variable amount of pixels to density independent pixels and vice-versa.
This formula (px to dp): dp = (int)(px / (displayMetrics.densityDpi / 160)); does not work on sm...
Reinhart asked 29/11, 2011 at 10:38
3
Solved
I need an excel formula that calculates the SUM of all column cells from a fixed level until the last cell in the column. Like : SUM from S5 to the last S cell.
I tried : SUM(S5:S) but doesn't work...
3
Solved
I've sorted a chunk of data into sub-totaled fields using the Subtotal tool under the Data tab. However, you are only able to choose one formula to apply.
How can I apply a separate formula to on...
1
I'm trying to use this answer, but set it up where the Function is in another xlam workbook.
Example:
This works from remote workbook:
Sub Test()
FuncName = "#MyFunctionkClick()"
MyVal ...
5
We're developing runscripts and try to support something like brew install runscripts.
It's written in golang and have some dependencies which required to go get. Now I have no idea to write the F...
7
Solved
I'm doing a hlookup against a value that spans multiple columns. My data is similar to this:
A B C D
---------------------------
1| Col1 Col2
2| x y z w
3|
4|
In rows 3 and 4 (A3, B3, C3, D3...
Delightful asked 15/1, 2009 at 17:22
9
Solved
i need to know how can i exclude 0 from rows and get the MIN Value.
But also i need to exlude the F1 Cell.
Ex:
A B C D E F
1 0 18 20 0 150 = 18
but if i do this In excel with =MIN(A1,B1,C1,D1,...
2
Solved
I have a simple formula in A1 cell =sum(A2:A10). Now in a B1 position lets say I put A15 and I would like it to modify a formula in cell A1 to be like this: =sum(A2:A15).
So basicly I would like to...
Hibben asked 26/11, 2014 at 23:16
9
Solved
I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?
Weightlessness asked 17/12, 2010 at 15:17
6
Solved
Given two degrees on a 360 degree circle. Lets call them Source and Destination.
For example Source could be 120 degrees and Destination could be 30 degrees.
Is there an elegant solution to the q...
2
I read several old posts about Google Spreadsheet missing the evaluate function.
There is any solution in 2016?
The easiest example.
'A1' contains the following string: UNIQUE(C1:C5)
'B1...
Koerlin asked 15/3, 2016 at 13:31
5
Solved
I am wondering if there is a general formula of some sort that can take a single incrementing integer, and run it through a modulus sort of thing to shift it to a random place, so as you increment ...
Gerontocracy asked 11/1, 2021 at 3:33
4
Solved
How to get the first and last day of the previous month in Google Sheets?
Martyrize asked 29/6, 2015 at 10:23
4
Solved
I have an lm object and want to get the formula extracted with coefficients. I know how to extract the formula without coefficients, and how to get the coefficients without the formula, but not how...
Copt asked 21/1, 2014 at 21:48
3
Solved
I wrote a =QUERY formula in Google spreadsheet. However I would like to copy not only the values of the cells but also the embedded links from the range of cells I am performing the query on. This ...
Gypsum asked 19/7, 2016 at 16:20
8
Solved
I am trying to split a string in an excel formula, something like I can do in many programming languages, e.g.
string words = "some text".split(' ');
The problem is that I can't be sure that the...
Ostap asked 23/6, 2009 at 8:21
© 2022 - 2024 — McMap. All rights reserved.