Incrementing Data

[chaboyski]

Hi,

just wanted to ask, what formula could i use if for example, the difference between column B and C would be added/deducted to the next day onwards to column B.

Table below would show the progression but the output should only be 1 table

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Data	Actual Data			Data	Actual Data			Data	Actual Data			Data	Actual Data
2	1-Aug	100			1-Aug	100	50		1-Aug	100	50		1-Aug	100	50
3	2-Aug	100			2-Aug	150			2-Aug	150	100		2-Aug	150	100
4	3-Aug	100			3-Aug	150			3-Aug	200			3-Aug	200	100
5	4-Aug	100			4-Aug	150			4-Aug	200			4-Aug	200	400
6	5-Aug				5-Aug				5-Aug				5-Aug
7	6-Aug				6-Aug				6-Aug				6-Aug
8	7-Aug	200			7-Aug	250			7-Aug	300			7-Aug	100
9	8-Aug	200			8-Aug	250			8-Aug	300			8-Aug	100
10	9-Aug	200			9-Aug	250			9-Aug	300			9-Aug	100
11	10-Aug	200			10-Aug	250			10-Aug	300			10-Aug	100
12	11-Aug	200			11-Aug	250			11-Aug	300			11-Aug	100
13	12-Aug				12-Aug				12-Aug				12-Aug
14	13-Aug				13-Aug				13-Aug				13-Aug
15	14-Aug	300			14-Aug	350			14-Aug	400			14-Aug	200
Sheet1

 

[chaboyski]

i tried using if but it would only allow me to add to the next cell and not the overall.

Book1
	A	B	C	D	E
1		Orig Data	Moving Data	Actual Data	Difference
2	1-Aug	100	100	50	50
3	2-Aug	100	150
4	3-Aug	100	100
5	4-Aug	100	100
6	5-Aug		0
7	6-Aug		0
8	7-Aug	200	200
9	8-Aug	200	200
10	9-Aug	200	200
11	10-Aug	200	200
12	11-Aug	200	200
13	12-Aug		0
14	13-Aug		0
15	14-Aug	300	300
Sheet2

Cell Formulas
Range	Formula
E2	E2	=C2-D2
C3:C15	C3	=IF(D2="",B3,B3+E2)