Surveys Needed Calculator

[Grayanz22]

Good Day!

I wanted to make a calculator to determine the number of perfect surveys needed to reach the target.
Please see details below:

Current score: 96.77%
# of Surveys: 31 (30 satisfied / 1 dissatisfied)
Goal: 98%

Appreciate any help ?

 

[tyija1995]

Hey,

Is the number of surveys fixed at 31? This is hard to determine, you can use Goal Seek to calculate a number of surveys based on the 98% criteria but again, this isn't very obvious, using goal seek gets 30.38 surveys (30.38 / 31 = 98%) but this sounds illogical as you can't have 0.38 of a survey? If it remained fixed that only 1 survey was dissatisfied then you would want 49 / 50 surveys to reach 98%

 

[AhoyNC]

See if this link helps.
https://www.mrexcel.com/forum/excel...umbers-scores-get-average.html?highlight=goal