simple subtraction

  • Thread starter Thread starter jlk
  • Start date Start date
J

jlk

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?
 
You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3
 
Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?
 
Enter the formula in D3
Select D3
Choose Edit->Copy
Select from D3 down to the last cell in Col D
Choose Edit->Paste
 
If your data begins in C1, just enter

=C2-C1

and then select all the cells down column D and then press CTRL R (or
choose Fill Down on the Edit menu) to fill the formula down all the
rows in the selected range. Excel will automatically change the row
numbers in the formula as it fills down. Of course, if your data
starts on a row other than 1, change the row numbers in the original
formula to those row numbers.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the "--" (double dash) in MS Excel formula? 2
Scrabble Value calculation for Welsh words 0
Complex function needed? 5
Creating a dynamic range always using the last 10 rows of data 3
Sum Column above current cell dynamically using function call 7
hardcode a column in a formula 2
Sum if value above is X 3
Subtracting first and last values in a row to find net difference 10

Back
Top