When you want to display a percentage in Excel use the Percentage number format which will automatically display a decimal value as a percentage. Enter the formula C2B2 in cell D2 and copy it down to as many rows as you need. To increase a number by a percentage in Excel execute the following steps.
Simple percentage formula in Excel You can easily apply the formula to subsequent rows by double-clicking the bottom right corner of the cell in this case.
Percent Change New Value Old Value Old Value. For example if we have 2 numbers then to find the percentage increase we will first subtract the smaller number from a bigger number and then divide the obtained value with a smaller number among both the values. Although theres no basic percentage formula in Excel you can multiply a number by a percentage using a formula. Change changeinitial value 100.