If your Microsoft Excel kung-fu is a little rusty, calculating your Net Promoter Score can seem intimidating. But worry not … it’s a lot easier than you might think!
Let’s say you have an Excel spreadsheet containing all of your survey responses. Each row in your spreadsheet contains a unique response. To make things easy, let’s assume that the answer to the ‘likelihood to recommend’ question is contained in Column A. Your spreadsheet should look a little bit like this example:
To calculate your Net Promoter Score, simply paste the following formula into any cell (one caveat: you cannot paste this formula into the same column that contains the answer to your ‘likelihood to recommend’ question or else you will get a circular reference error.)
If the answer to your ‘likelihood to recommend’ question appears in a different column, simply change all instances of A:A the formula above to reference the appropriate column name. So, for example, if the answer to your ‘likelihood to recommend’ question is in Column E, replace all three instances of A:A with E:E as illustrated below: