Formula New Salary - Old Salary Old Salary 100 percentage increase. Percent increase new value - original valueoriginal value 100. Percentage increase new number - old number old number x 100 NOTE.
Enter a decimal number 02 in cell B1 and apply a Percentage format.
This is shown in the formula below. These formulas simply multiply the value by five percent more than the whole of itself 100 percent. As a result a 20 percent increase would be multiplied by 120 percent and a 15 percent increase would be 115 percent or 115. You can calculate the percentage increase due to a raise in salary by using the following formula.