#### quickhappy

##### Board Regular

- Joined
- Dec 21, 2013

- Messages
- 65

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.