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!
[TABLE="width: 498"]
<tbody>[TR]
[TD="class: xl65, width: 110, bgcolor: #F2F2F2"][/TD]
[TD="class: xl67, width: 110, bgcolor: #C9C9C9"]PTs
[/TD]
[TD="class: xl67, width: 110, bgcolor: #C9C9C9"]WELDS
[/TD]
[TD="class: xl69, width: 110, bgcolor: #C9C9C9"]PTd %
[/TD]
[TD="class: xl69, width: 110, bgcolor: #C9C9C9"]GOAL %
[/TD]
[TD="class: xl71, width: 110, bgcolor: #C9C9C9"]PTs NEEDED TO REACH GOAL
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #C9C9C9"]CT
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]12
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]67
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]17.9%
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]15.0%
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #C9C9C9"]MH
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]15
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]110
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]13.6%
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]15.0%
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #C9C9C9"]SM
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]15
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]119
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]12.6%
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]15.0%
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #C9C9C9"]SR1
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]13
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"]132
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]9.8%
[/TD]
[TD="class: xl70, bgcolor: #F2F2F2"]15.0%
[/TD]
[TD="class: xl68, bgcolor: #F2F2F2"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the forum.

Try:

	A	B	C	D	E	F

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #C9C9C9"]PTs[/TD]
[TD="bgcolor: #C9C9C9"]WELDS[/TD]
[TD="bgcolor: #C9C9C9"]PTd %[/TD]
[TD="bgcolor: #C9C9C9"]GOAL %[/TD]
[TD="bgcolor: #C9C9C9"]PTs NEEDED TO REACH GOAL[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #C9C9C9"]CT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]67[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]17.91%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15.00%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "]Goal met[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #C9C9C9"]MH[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]110[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]13.64%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15.00%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]2[/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "][/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: #C9C9C9"]SM[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]119[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]12.61%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15.00%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]3[/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "][/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: #C9C9C9"]SR1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]13[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]132[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]9.85%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]15.00%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: right"]7[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F2[/TH]
[TD="align: left"]=IF(A2="","",IF(B2/C2>=E2,"Goal met",ROUNDUP(C2*E2-B2,0)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]