Getting numbers of scores to get average

[Rara1424]

Hi guys,

Need some experts to shed light on me. Trying to come up with a formula to get how many 100% scores do I need to get to 98% if my table looks like this:

Current Attempts	Running Score	Goal	How many 100% audits needed?
<help here>

<colgroup><col><col><col><col></colgroup><tbody>
[TD="align: right"]87[/TD]
[TD="align: right"]96%[/TD]
[TD="align: right"]98%[/TD]

</tbody>

Many thanks in advance
-R

 

[Eric W]

Welcome to the forum.

Try:

Excel 2012

	A	B	C	D
Current Attempts	Running Score	Goal	# of 100s needed

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]96%[/TD]
[TD="align: right"]98%[/TD]
[TD="align: right"]87[/TD]

</tbody>

Sheet1​

[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] "]D2[/TH]
[TD="align: left"]=A2*(C2-B2)/(1-C2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rara1424]

Welcome to the forum.

Try:

Excel 2012

	A	B	C	D
Current Attempts	Running Score	Goal	# of 100s needed

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]96%[/TD]
[TD="align: right"]98%[/TD]
[TD="align: right"]87[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]D2[/TH]
[TD="align: left"]=A2*(C2-B2)/(1-C2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Wow. you made it look easy. Super thanks Eric!!!

 

[Eric W]

Just a little algebra! Glad to help!