How To Calculate Net Promoter Score In Excel. Now, how do you do the math to start your nps calculation? Divide the answer to that by the total number of responses, then multiply it by 100.
How to calculate nps in excel: Now, calculate the percentage of promoters (61.5%) and detractors (11.6%). Repeat this process for detractors;
If it is, then this is your score.
The percentage of detractors is then subtracted from the percentage of promoters to obtain a net promoter score (nps). For example, if you had 100 responses with 60 promoters (promoters = 60 per cent) and 20 detractors (detractors = 20 per cent) this formula would become: Since then, many organizations use it. A step by step guide for nps calculation.