I need to calculate what percentage one number is of another on a relatively regular basis. Luckily, it is relatively easily done using functions in Excel. Here’s how:

Leave a Comment# Tag: percentage

If you do a lot of work in Excel, odds are you’ve needed to calculate a percentage change. Luckily, Excel does this for you quite readily if you simply apply a basic formula of `(New Value - Old Value)/Old Value`

. There is, however, a pitfall that you’ll not get the values you expect if the cell where you’re entering the value is not set to percentage formatting. Hence, here’s a step to step way to make the calculation: