How to Calculate the Percentage Difference between 2 values

preview_player
Показать описание
This video goes over a quick example on how to calculate the difference between two values in excel. There are many scenarios in HR and compensation that you would want to use this formula – with salary ranges, salary increases, market rates, etc. This formula also comes in handy for small businesses calculating year over year sales volume changes or rental property market changes. What percentage difference are you looking to calculate?

Рекомендации по теме
Комментарии
Автор

What you are showing is actually the percente change between the new and old values, not the percent difference. The percent difference would be the difference between the two values divided by their average.

francoisdessureault