For example to calculate the Monthly Change and Total Change. To decrease a number by a percentage amount multiply the original amount by 1- the percent of increase. You subtract the second number.
To calculate the growth rate youre going to need.
Select cell C3 and enter the formula shown below. As a result a 20 percent increase would be multiplied by 120 percent and a 15 percent increase would be 115 percent or 115. Select cell C3 and enter the formula shown below. The percent change formula is used very often in Excel.