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?
87	96%	98%	<help here>

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Many thanks in advance
-R

 

[Eric W]

Welcome to the forum.

Try:

Excel 2012

	A	B	C	D
1	Current Attempts	Running Score	Goal	# of 100s needed
2	87	96%	98%	87

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

Sheet1​

Worksheet Formulas Cell Formula D2 =A2*(C2-B2)/(1-C2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Rara1424]

Welcome to the forum.

Try:

Excel 2012

	A	B	C	D
1	Current Attempts	Running Score	Goal	# of 100s needed
2	87	96%	98%	87

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =A2*(C2-B2)/(1-C2) <tbody> </tbody>

<tbody>
</tbody>

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

 

[Eric W]

Just a little algebra! Glad to help!