Successive Discounts

[mistersteve]

Sorry to ask such a simple formula, but for some reason i have a brain freeze on this one

I have a gross price and wish to apply up to three successive discounts showing the Total discount overall
[TABLE="width: 785"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 903"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 903"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Qty.[/TD]
[TD]Gross[/TD]
[TD]Disc.1 %[/TD]
[TD]Result 1[/TD]
[TD]Disc.2 %[/TD]
[TD]Result 2[/TD]
[TD]Disc.3 %[/TD]
[TD]Result 3[/TD]
[TD]Total Discount[/TD]
[TD]Unit Nett[/TD]
[TD]Total Nett[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]50[/TD]
[TD]20[/TD]
[TD]40.00[/TD]
[TD]25[/TD]
[TD]30.00[/TD]
[TD]25[/TD]
[TD]22.50[/TD]
[TD] [/TD]
[TD]22.50[/TD]
[TD]22.50[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1	Qty.	Gross	Disc.1 %	Result 1	Disc.2 %	Result 2	Disc.3 %	Result 3	Total Discount	Unit Nett	Total Nett
2	1	50	20	40	25	30	25	22.5	0.55	22.5	22.5
Sheet5

Cell Formulas
Range	Formula
D2	=B2*(1-C2/100)
F2	=D2*(1-E2/100)
H2	=F2*(1-G2/100)
I2	=(B2-H2)/B2
J2	=H2
K2	=H2

 

[mistersteve]

Thanks for that,

what if i wanted to not have the formulas in cells D2 F2 and H2 and still have the final result anyway in I2

 

[sheetspread]

If you have the percentages:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1	Qty.	Gross	Disc.1 %	Result 1	Disc.2 %	Result 2	Disc.3 %	Result 3	Total Discount	Unit Nett	Total Nett
2	1	50	20	40	25	30	25	22.5	0.55	22.5	22.5
Sheet5

Cell Formulas
Range	Formula
I2	=1-((100-C2)/100)*((100-E2)/100)*((100-G2)/100)

 

[mistersteve]

Again thanks Sheetspread
last question - sorry.
Based on no results in D2 F2 and H2 how do I solve cell J2 to give same result

 

[sheetspread]

This?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1	Qty.	Gross	Disc.1 %	Result 1	Disc.2 %	Result 2	Disc.3 %	Result 3	Total Discount	Unit Nett	Total Nett
2	1	50	20		25		25			22.5
Sheet5

Cell Formulas
Range	Formula
J2	=B2*((100-C2)/100)*((100-E2)/100)*((100-G2)/100)

 

[mistersteve]

Thanks, I came up with this formula

J2 (B2/100)*(1-I2)*100