topgun1303
New Member
- Joined
- Sep 24, 2008
- Messages
- 19
In the below chart, I am trying to create a formula to calculate the change from the previous month. When I right click to insert a column the formula does update automatically to shift the reference. Any ideas on a formula to do this?
<tbody>
</tbody>
June | July | August | Change |
96 | 99 | 95.49 | =(E3 - D3) |
71 | 84 | 82.71 | |
85 | 89 | 90.98 | |
100 | 100 | 100 |
<tbody>
</tbody>