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

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

<colgroup><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[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