Formula to calculate value based on % thresholds

Hello All

I have been trying to create a formula that will take a value and compare it to a set of thresholds.

I have attached a spreadsheet which shows the sort of information I have and the required results (highlighted in green). I am able to calculate the values manually but I really need to be able to have a formula that will cover all eventualities.

Any help will be gratefully received

Thanks very much

Jim

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		A	B	C	D	E		Threshold	0	2	4	6	8
2	Value	1	3	3	1	2		Multiplier	0.8	0.7	1.4	1.05	1.05
3	Cumulative	1	4	7	8	10			0.8	-0.1	0.7	-0.35	0	I3 and across: =I2-N(H2)
4	Value After Multiplier	0.8	2.2	3.85	1.05	2.1								B4 and across: =SUMPRODUCT((B3>$I$1:$M$1) * (B3-$I$1:$M$1) * $I$3:$M$3) - SUM($A4:A4)

You're welcome.