![]() |
|
|||||||
![]() |
|
Microsoft Excel formula?
|
![]() |
LinkBack | Thread Tools | ![]() |
Display Modes | ![]() |
|
|||
|
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. |
| Links |
|
|
|
|||
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
|
|