Thanks to SmartSurvey, our communication strategy is making us stand out from the crowd. By using SMS, asking the right questions and acting on results, IKEA is one step ahead of the competition.
How is NPS® Calculated?
How is NPS® Calculated?
![Screenshot of our NPS calculator tool](jpg/6431842eb03b847b87d6a81a_nps-calculator-1024x512.jpg)
Trying to work out the calculation to your Net Promoter Score® survey can seem a little daunting at first, but with the right explanation, tools and formulae, you’ll soon understand how to calculate this and get the answers you need.
Calculating your NPS
Your Net Promoter Score is calculated by working out the difference between the proportion of promoters and detractors, to generate a score of between -100 and 100.
How you calculate NPS will depend on the size of your data set, as there are number of approaches you can take:
A simple manual calculation:
You need to subtract the number of detractors from the number of promoters, which will leave you with a positive or negative number.
You then need to divide that answer by your total number of survey responses and multiply that by 100.
The number you get, rounded to the nearest whole number, should be between 100 and –100.
NPS excel formula:
For a larger data sets, which would be more time consuming to calculate manually you can work out your NPS with the following single spreadsheet formula:
=ROUNDUP((100*((COUNTIF([Data],">8")-COUNTIF([Data],">7"))/COUNT([Data]))),0)
Paste this into Excel or Google Sheets (or other spreadsheet), and just replace [Data] with the data range in your response spreadsheet that has the NPS answers in it.
Then simply run the formula and your score should appear right in front of you.
Net Promoter Score tool:
With more survey providers offering tools to work out your NPS, it’s becoming easier than ever to calculate.
If you’ve already captured your responses you can use our free NPS calculator to work out your score.
For customers on our Business plans and above we’ve built a tool into our Net Promoter Score question that will collect data that’s automatically processed to show you the correct score via our reporting tools.
More about NPS
- How to use the NPS question
- A Net Promoter Score example
- What is a good NPS score?
- The benefits of using NPS
Get started with NPS
To start capturing your Net Promoter Score, sign up to SmartSurvey or speak to our sales team.
NPS®, Net Promoter® & Net Promoter Score® are registered trademarks of Satmetrix Systems, Inc., Bain & Company and Fred Reichheld.
How are we different?
UK based
Your data will be stored and processed here in the UK for your peace of mind.
Fanatical support
We pride ourselves on going above and beyond for our customers, providing expert advice and support whenever you need it.
You're in safe hands
Our secure platform and robust data protection measures ensure your data is safe and secure with us. We are ISO27001 and Cyber Essentials Plus certified.
We're human
We understand the importance of personal interaction, which is why we offer a human touch alongside our cutting-edge technology.
Accessibility matters
We're committed to making our surveys accessible to everyone, with a range of features to support those with disabilities.
Unlimited responses
With no limits on the number of responses you can collect, you can be sure your survey will reach as many people as possible without it being cost prohibitive.
![](png/6492c8bd2c27d25d876bdff3_safe-hands.png)
Don't just take our word for it
Over 500,000 users have registered to use SmartSurvey.
![Dunelm logo](https://assets-global.website-files.com/63ece81ba4a783f18434aad2/63ee6518a40ffdca1c7ed6fd_Frame 26.webp)
We couldn't be happier with SmartSurvey, we love its functionality and flexibility. This means we have been able to use one survey tool across many parts of the business.
![Awards certificates](https://assets-global.website-files.com/63ece81ba4a783f18434aad2/63ef8a8f0bc9d8fe324cdec2_awards-left.webp)
![Awards certificates](https://assets-global.website-files.com/63ece81ba4a783f18434aad2/63ef8a9c1ad44e42810318d1_awards-right.webp)
Get in touch
We are ISO27001 certified, registered under the Data Protection Act and fully compliant with EU Privacy Laws.
Access to a knowledgeable account manager for personal assistance for when you most need it.
Our friendly design team is on hand to assist with any bespoke design and custom development requests.
We succeed if you succeed. Our goal is to help you carry out effective research and we’re here to help you achieve that.