The NPS Calculation Formula To calculate your Net Promoter Score, subtract the percentage of Detractors from the percentage of Promoters. NPS = % promoters - % detractors. For example, if 50% of respondents are Promoters, 10% are Detractors, and 40% are passives, your NPS would be 50-10=40.
- How is NPS calculated?
- Why do we calculate NPS?
- Is there an NPS formula in Excel?
- Is NPS calculated in percentage?
How is NPS calculated?
Calculating your NPS score is as simple as tallying up your responses and subtracting the percentage of detractors from the percentage of promoters. For example, if 60% of respondents are promoters, 10% are detractors, and 30% are passives, your NPS would be 60-10=50.
Why do we calculate NPS?
NPS is a benchmarking tool for customer satisfaction. The NPS method, which is based on a two-minute survey, gives insights about customer loyalty by measuring customers' willingness to recommend a business to a friend or acquaintance.
Is there an NPS formula in Excel?
The Formula to Calculate NPS in Excel/Google Sheets
Find the percentage of Promoters – Divide the number of promoters by the total number of respondents and then multiply by 100.
Is NPS calculated in percentage?
The NPS is not expressed as a percentage but as an absolute number lying between -100 and +100. For instance, if you have 25% Promoters, 55% Passives and 20% Detractors, the NPS will be +5.