Formula to get quantity as a percentage of cell value

[redspanna]

Hi all
So on the example shown I have the current 'Holding' value stored in H8
Once user inputs the % to sell into cell D11:D15 I would like that percentage shown in E11:E15 as a current value of cell H8

DCA Calc.xlsm
	B	C	D	E	F	G	H	I	J	K
2
3
4
5
6		HOLDING	123,456.00
7
8							123,456.00
9
10		PRICE	% TO SELL	QUANTITY
11
12
13
14
15
16
Sheet1 (2)

Cell Formulas
Range	Formula
H8	H8	=SUM(D6)-(SUM(E11:E15))

Cells with Data Validation
Cell	Allow	Criteria
D5:E5	List	=$AB$4:$AB$11

So for example:
If user inputs 10 into D11, the formula needed in cell E11 would equate to what 10% of the current value in cell H8 is = so the result in E11 would be 12,345.60 and H8 will reduce to 111,110.40
if the user then inputs 10 into D12, the formula needed in cell E12 would equate to what 10% of the current value in cell H8 is = so H8 will now hold 111,110.40 (123,456.60 - 10%), therefor the result now in E12 would be 111,110.40 - 10% so 11,111.04, and so on with any inputs added to cells in D13:D15

FYI - the original starting balance for cell H8 is held in Cell D6

hope this makes sense

 

[Fluff]

How about

=IF(D11="","",0.1*($D$6-SUM(E$10:E10)))

 

[redspanna]

How about

=IF(D11="","",0.1*($D$6-SUM(E$10:E10)))

Changed slightly to

=IF(D11="","",D11%*($D$6-SUM(E$10:E10)))

so instead of the 0.1 (10%) being hard coded into the formula , I changed it as required to indicate the value (as a %) in D11

Thanks a lot

 

[Fluff]

Glad to help & thanks for the feedback.