How to calculate number required to achieve target percentage

[ellery33]

Hello all,

Here at work, I need to figure out how many more PTs are needed to reach the target goal of 15%. What formula can I use in order to get the amount without figuring it out myself. Any help is greatly appreciated. Thanks!

	PTs	WELDS	PTd %	GOAL %	PTs NEEDED TO REACH GOAL
CT	12	67	17.9%	15.0%
MH	15	110	13.6%	15.0%
SM	15	119	12.6%	15.0%
SR1	13	132	9.8%	15.0%

<tbody>
</tbody>

 

[Eric W]

Welcome to the forum.

Try:

	A	B	C	D	E	F
1		PTs	WELDS	PTd %	GOAL %	PTs NEEDED TO REACH GOAL
2	CT	12	67	17.91%	15.00%	Goal met
3
4	MH	15	110	13.64%	15.00%	2
5
6	SM	15	119	12.61%	15.00%	3
7
8	SR1	13	132	9.85%	15.00%	7

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula F2 =IF(A2="","",IF(B2/C2>=E2,"Goal met",ROUNDUP(C2*E2-B2,0))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>