raytehawsome
New Member
- Joined
- Jul 3, 2018
- Messages
- 6
Hi There,
I am wondering if I could get some help. At work we calculate customer satisfaction with NPS surveys, which is percentage of promoters (rating of 9 or 10) minus percentage of detractors (rating of 6 or below). Our NPS score is calculated as ((Promoters/Total Surveys)-(Detractors/Total Surveys). With that, I currently have this set up in Excel:
<colgroup><col width="144" style="width: 108pt; mso-width-source: userset; mso-width-alt: 5266;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Yellow is what I change, NPS is set up as =(B3/B6)-(B5/B6), and Total # of Surveys is just =C4+C5+C6.
I would like to create an additional an additional line below, # of Promoters to 90%. I have used Goal Seek to find the number, but I have not figured out a way to display it. I am wondering if I could get some help from someone to figure out a formula in order to figure out how many more Promoters I need to hit a certain percentage. I appreciate the help, and thank you in advance!
I am wondering if I could get some help. At work we calculate customer satisfaction with NPS surveys, which is percentage of promoters (rating of 9 or 10) minus percentage of detractors (rating of 6 or below). Our NPS score is calculated as ((Promoters/Total Surveys)-(Detractors/Total Surveys). With that, I currently have this set up in Excel:
Quarter NPS | |
NPS | 79% |
Promoters | 30 |
Passives | 1 |
Detractors | 3 |
Total # of Surveys | 34 |
Yellow is what I change, NPS is set up as =(B3/B6)-(B5/B6), and Total # of Surveys is just =C4+C5+C6.
I would like to create an additional an additional line below, # of Promoters to 90%. I have used Goal Seek to find the number, but I have not figured out a way to display it. I am wondering if I could get some help from someone to figure out a formula in order to figure out how many more Promoters I need to hit a certain percentage. I appreciate the help, and thank you in advance!