Type the following formula into any Excel cell. Then type the following formula. Below is the formula to calculate the percent change in general.
To show a number as a percent in Excel you need to apply the Percentage format to the cells.
Number percent 100. For example 11 is actually stored as 011 and Excel uses this underlying value in all formulas and calculations. To Excel the percent symbol is just formatting. We want to show the total estimated amount not just the increase.