Multiple conditions to look at

[AndrePrevin]

Hi all

I have 4 columns of data
in column A I have some random values and mostly blanks. in column B I have a calculation which looks at column A and if a value appears there it discards the values above it and takes the new value from column A.
In column C I have a formula = =IF(D2>0,B2-D2,B2)
The problem is, when column D is blank, column C just pulls the values from column b, obviously, but what I want it to do is, when it encounters a value in column D, it must calculate B2 - D2 and output the value but then on the next cell down it must increment by the same increment value which it sees in column B


Pardon my poor explanation but I hope this illustrates what I want to do a bit better:

A	B	C	D
	10	10
	11	11
5	5	5
	6	6
	7	7
	8	3	5
	10	5
	10	5
	11	6
8	8	8
	9	9
	13	8	5
	15	10

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Don't know if this helps to understand my problem but essentially I want to create a formula in column C that can work with multiple conditions, like whether or not a value appears in column D and what sort of increment occurs in column B

Kind regards

 

[handysmurf]

Cell C14 = "=IF(ISBLANK(D14),C13+(B14-B13),B14-D14)"