Tag: percentage

Excel: Calculate percentage
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: For the purposes of this example, let’s assume that the source number (i.e. the one which we are comparing with) is in field A12, and the number…

Calculating percentage change in Excel
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…