Enter a Percentage | Percentage of Total | Increase by Percentage | Percentage Change

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.

1. First, enter a decimal number.

2. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

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.

1. Enter the formula 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 (=).

2. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

Result.

3. On the Home tab, in the Number group, click the Increase Decimal button once.

Result.

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.

1. Enter a number in cell A1. Enter a decimal number (0.2) in cell B1 and apply a Percentage format.

2. To increase the number in cell A1 by 20%, multiply the number by 1.2 (1+0.2). The formula below does the trick.

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.

3. To decrease a number by a percentage, simply change the plus sign to a minus sign.

### Percentage Change

To calculate the percentage change between two numbers in Excel, execute the following steps.

1. Enter an old number in cell A1 and a new number in cell B1.

2. First, calculate the difference between new and old.

3. Next, divide this result by the old number in cell A1.

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.

4. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.

Result.

5. The (New-Old)/Old formula always works.

Note: visit our page about the percent change formula for a practical example.

**版权声明：**本文为4find – 解决程序猿问题原创文章，欢迎转载。转载请务必注明出处！ （参考格式：本文转自4find – 解决程序猿问题，原文地址：http://4find.cc/archives/592）