quickhappy
Board Regular
- Joined
- Dec 21, 2013
- Messages
- 65
Hi Need a formula to calculate this. See below.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Ok, the above data has "NPS Score" column. That data is calculated by the number in "promoters" - "Detractors" / by "total". What I want is a formula that will calculate how many promoters I need to reach a 90% score in "NPS Score".
Example 1. Row "alamogordo" has 47 promoters with 3 detractors with a total of 53. So 47-3=44 and 44/53 = 83.02........ So how many more promoters do I need to bring NPS Score to 90%.
Thanks for your help.
Row Labels | Promoters | Detractors | Total | CSAT Score | NPS Score |
ALAMOGORDO | 47 | 3 | 53 | 96.66 | 83.02% |
JODY WELLS | 9 | 9 | 99.45 | 100.00% | |
ADAM WALOWITZ | 17 | 2 | 21 | 91.64 | 71.43% |
NOE VALDEZ | 15 | 16 | 95.55 | 93.75% | |
ADAN GUZMAN | 6 | 1 | 7 | 100.00 | 71.43% |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Ok, the above data has "NPS Score" column. That data is calculated by the number in "promoters" - "Detractors" / by "total". What I want is a formula that will calculate how many promoters I need to reach a 90% score in "NPS Score".
Example 1. Row "alamogordo" has 47 promoters with 3 detractors with a total of 53. So 47-3=44 and 44/53 = 83.02........ So how many more promoters do I need to bring NPS Score to 90%.
Thanks for your help.