Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Microsoft Excel formula?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-08-2007, 01:11 PM
Junior Member
 
Join Date: Nov 2007
Posts: 1
Default Microsoft Excel formula?

Is there a way to set of a formula for this:

In the fifth column, calculate ?V (the change in volume, which is Vn+1– Vn). For example, the change in volume from the first data point (V1) to the second data point (V2) is ?V = V2 – V1.
Reply With Quote
Links
  #2 (permalink)  
Old 11-08-2007, 01:11 PM
Junior Member
 
Join Date: Sep 2007
Posts: 18
Default

In Excel columns are letters and rows are numbers

Column 5 is column E

Assume you start with row 3
Let cell E2 = Vstart

Set V1 as column C
Set V2 as column D
The formula in column 5 will be
V2 – V1
or formula
=D3-C3+E2

Now this will give you the difference. But you are asking for the delta change. And you are not including enough data to write a calc formula.

But a total change is
V1V2
Vstart1
1232
2343
3454
4565

Sorry the ascii format will not let this chart display correctly
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:39 PM.