Related
Morgan: First time asking here. This is on Google Sheets! In the attached picture, page 13 is on the right. The worksheet on the left is where the equations are entered, we can call it worksheet 1. Here is my equation: =INDEX(Sheet13!G:G,MATCH(N2781, Sheet13!A
distressed: I want to find the difference between two numbers in Go, the result should not be in "-". Please find my code below: dollarValue := 240000 - 480000
The result is "-240000". But my expected output is only "240000". Can anyone help how to calc
distressed: I want to find the difference between two numbers in Go, the result should not be in "-". Please find my code below: dollarValue := 240000 - 480000
The result is "-240000". But my expected output is only "240000". Can anyone help how to calc
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
Sanju I am trying to find the percentage difference of two numbers. The reality is that iam gets the total value of user data for this week and last week. Now I need to see the percent difference in performance between this week's data and last week's data. Be
bra PV formulas on Google Sheets can have 3, 4 or 5 parameters. I'm trying to calculate the current value given a parameter in JavaScript, but can't seem to figure out or find the formula Google Sheets is using. The arguments that are currently being passed to
Gibronin I have two columns in Google Sheets, column 1 is a list of my times on a track in "01:23.456" or "minutes:seconds.milliseconds" format. Column 2 lists the time someone was on a track in the same format. I'm looking for a way to calculate the time diff
LyonsTheWay2Gold I am trying to display a percentage after subtracting a number. example: Job Cost = £165.00Worker Charges = £42.00Surplus =% What percentage of costs are left after workers take a pay cut? My code output shows 0 int number = 0, number1, result
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
bra PV formulas on Google Sheets can have 3, 4 or 5 parameters. I'm trying to calculate the current value given a parameter in JavaScript, but can't seem to figure out or find the formula Google Sheets is using. The arguments that are currently being passed to
Sraymond This is an algorithmic question. For simplicity, let's say I have two doubles A and B. I want to construct a function that will take me until the next multiple of A or the next multiple of B. For example, let's say A is 3 and B is 5. Consider multiple
Danilov We are requesting assistance in creating a script to calculate how often transactions are processed for an identification number per month. In the (December) table, in column (A), we list all transactions requested for that month, listed by identificat
Adnan Really appreciate some help with this issue I've been struggling with. I believe the answer is somewhere in Match, Index, Indirect, ArrayFormula, but I'm having a hard time finding it. So my main goal is to get the cost of the product based on 3 (technic
distressed: I want to find the difference between two numbers in Go, the result should not be in "-". Please find my code below: dollarValue := 240000 - 480000
The result is "-240000". But my expected output is only "240000". Can anyone help how to calc
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
Brondby If the smallest number is 15 and the largest number is 200 , what formula do I need to use to define a multiplication pattern that applies the 28 values needed to complete that multiplication table? I want to learn how to create this pattern to use, I
Brondby If the smallest number is 15 and the largest number is 200 , what formula do I need to use to define a multiplication pattern that applies the 28 values needed to complete that multiplication table? I want to learn how to create this pattern to use, I
Sanju I am trying to find the percentage difference of two numbers. The reality is that iam gets the total value of user data for this week and last week. Now I need to see the percent difference in performance between this week's data and last week's data. Be
Gibronin I have two columns in Google Sheets, column 1 is a list of my times on a track in "01:23.456" or "minutes:seconds.milliseconds" format. Column 2 lists the time someone was on a track in the same format. I'm looking for a way to calculate the time diff
Gibronin I have two columns in Google Sheets, column 1 is a list of my times on a track in "01:23.456" or "minutes:seconds.milliseconds" format. Column 2 lists the time someone was on a track in the same format. I'm looking for a way to calculate the time diff
LyonsTheWay2Gold I am trying to display a percentage after subtracting a number. example: Job Cost = £165.00Worker Charges = £42.00Surplus =% What percentage of costs are left after workers take a pay cut? My code output shows 0 int number = 0, number1, result
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
tom I have a spreadsheet like this. 2020-04-25 63
2020-04-26 34
2020-04-27 12
2020-04-28 33
2020-04-29 45
2020-04-30 10
2020-05-01 34
2020-05-02 12
2020-05-03 45
2020-05-04 18
2020-05-05 45
2020-05-06 21
2020-05-07 34
2020-05-08 56
2020-05-09 21
Brondby If the smallest number is 15 and the largest number is 200 , what formula do I need to use to define a multiplication pattern that applies the 28 values needed to complete that multiplication table? I want to learn how to create this pattern to use, I
Brondby If the smallest number is 15 and the largest number is 200 , what formula do I need to use to define a multiplication pattern that applies the 28 values needed to complete that multiplication table? I want to learn how to create this pattern to use, I
Tom Seawick Usually, I just want to calculate the difference for each row like this:=B1-A1 Then I would aggregate the values of that column like this =SUM(C1:C10)and get the desired value. I don't want column C. Is it possible to calculate immediately? For exa