Calculating percentages in Excel is easy. Percentage simply means 'out of 100', so 72% is '72 out of 100' and 4% is '4 out of 100', etc.
Enter a Percentage
To enter a percentage in Excel, execute the following steps.
First, enter a decimal number.
On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
Here the result.
Note: To change the percentage in cell A1, simply select cell A1 and type a new percentage (do not type a decimal number).
Percentage of Total
To calculate the percentage of a total in Excel, execute the following steps.
First, enter the formula is shown below. This formula divides the value in cell A1 by the value in cell B1. Simply use the forward slash (/) as the division operator. Don't forget, always start a formula with an equal sign (=).
On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
Here the result.
On the Home tab, in the Number group, click the Increase Decimal button once.
Here the result of percentage with one decimal place.
Note: Excel always uses the underlying precise value in calculations, regardless of how many decimals you choose to display.
Increase by Percentage
To increase a number by a percentage in Excel, execute the following steps.
First, enter a number in cell A1. Enter a decimal number (0.2) in cell B1 and apply a Percentage format.
To increase the number in cell A1 by 20%, multiply the number by 1.2 (1+0.2). The formula below does the trick.
To decrease a number by a percentage, simply change the plus sign to a minus sign.
Note: Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first.
Percentage Change
To calculate the percentage change between two numbers in Excel, execute the following steps.
Enter an old number in cell A1 and a new number in cell B1.
First, calculate the difference between new and old.
Next, divide this result by the old number in cell A1.
On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
Here the result.
The (New-Old)/Old formula always works.
Note: Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first.