Formula to figure out how many should I add to achieve the required %

[zinah]

Hi,

I know I may sound weird but suddenly my brain stopped and couldn't figure out the math :P. I have below table and what I need to achieve is, how many person should I add to achieve the % goal? I don't want to use solver, I need a formula.

Thank you!

Book7
	A	B	C	D
2	Totals	Current % (count)	Goals	How many should I add to achieve % Goal?
3	36	3% (1)	15%
4	36	14% (5)	20%
5	24	50% (12)	50%
6	20	5% (1)	15%
7	12	17% (2)	25%
8	6	33% (2)	50%
9	3	67% (2)	>50%
Sheet1

 

[Brunts]

in Cell D3 =ROUNDUP(C2*A2,0) (obviously will not like the > sign in Cell C9 - is it there on purpose?)

 

[zinah]

in Cell D3 =ROUNDUP(C2*A2,0) (obviously will not like the > sign in Cell C9 - is it there on purpose?)

Thank you for your input, when I tried your formula, it didn't achieve the required %. The formula should consider the current count which is the count in column B, I added column C to clarify more. Is there any other formula? As for C9, it's there on purpose so the goal should anything less than 50%

Book7
	A	B	C	D	E	F	G
1
2	Totals	Current % (count)	Current Count	Goals	How many should I add to achieve % Goal?
3	36	3% (1)	1	15%	6	5	14%
4	36	14% (5)	5	20%	8	3
5	24	50% (12)	12	50%	12
6	20	5% (1)	1	15%	3
7	12	17% (2)	2	25%	3
8	6	33% (2)	2	50%	3
9	3	67% (2)	2	>50%	#VALUE!
10
11
Sheet1

Cell Formulas
Range	Formula
G3	G3	=F3/A3
F3	F3	=E3-1
F4	F4	=E4-5
E3:E9	E3	=ROUNDUP(D3*A3,0)

 

[Brunts]

With your >50%, I would amend to a specific value e.g. 50% or 51% - all the other goals in the other rows are minimum amounts so there is an implied >=.
If the value in Column B was only a percentage amount (I don't like two separate data items in one cell) then formula in E3 =IF(C4>=E4,0,ROUNDUP(E4*A4,0)-D4)
Otherwise, amend formula in E3 to =ROUNDUP(D3*A3,0)-C3.

 

[zinah]

With your >50%, I would amend to a specific value e.g. 50% or 51% - all the other goals in the other rows are minimum amounts so there is an implied >=.
If the value in Column B was only a percentage amount (I don't like two separate data items in one cell) then formula in E3 =IF(C4>=E4,0,ROUNDUP(E4*A4,0)-D4)
Otherwise, amend formula in E3 to =ROUNDUP(D3*A3,0)-C3.

Thanks a lot, the 2nd formula worked for me