Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B. New value old value ABS old value. To show a number as a percent in Excel you need to apply the Percentage format to the cells.
Here is the formula that is commonly used.
Select a blank cell for locating the calculated percentage change then enter formula A3-A2A2 into the Formula Bar and then press the Enter key. Or we could write the formula as. Percentage of Total 1. For example if Septembers bill amount is in cell B4 and Octobers bill amount is in cell B5 your alternative Excel formula would be SUM B5-B4B4.