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…