How to put percentage formula in excel

Home » Excel-Formulas » Percentage-Of-Number

If you want to calculate a percentage of a number in Excel, simply multiply the percentage value by the number that you want the percentage of.

For example, if you want to calculate 20% of 500, multiply 20% by 500.

I.e. type the following formula into any Excel cell:

=20%*500

- which gives the result 100.

Note that the % operator tells Excel to divide the preceding number by 100. Therefore, the value 20% in the above calculation is evaluated as 0.2.

Further Examples of Calculating a Percentage of a Number

Example 1 - Percentages of Various Numbers

The following spreadsheet shows various percentage calculations for different numbers.

Example 2 - Sales Tax Calculation

The following spreadsheet shows the calculation of sales tax at 22.5%, of an invoice total.

For further examples of Calculating Percentages of Numbers in Excel, see the Microsoft Office website.

Or, for an overview of different types of percentage calculation, see the Percentages In Excel page.

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.

How do I automatically add a percentage in Excel?

How do you calculate 20% in Excel?

What is the formula to calculate percentage?