Ad powerful features built for business, designed for people, loved by teams. When you follow these steps on how to calculate net promoter score, the equation would look like this: Net Promoter Score Benchmarks to Help You Understand You can calculate net promoter score (nps) by subtracting the percentage of individuals who wouldn’t recommend you from the percentage of individuals who might do so. How to calculate net promoter score in excel . Let’s say you sent a standard nps question and received 1,000 responses in total. Divide the answer to that by the total number of responses, then multiply it by 100. How to calculate net promoter score in excel [template for. Percentage of promoters minus percentage of detractors Bain and company introduced nps first in 2004. Both version allow you to simply copy and paste your data into a column and automatically calculate the net promoter score and score ranges. To calculate your net promoter score, simply paste the follo...