Percentage Formula in Excel

Excel provides you different ways to calculate percentages. For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change between two values. Calculating a percentage in Excel is an easy two-step process. First, you format the cell to indicate the value is a percent, and then you build the percent formula in a cell.

How to Calculate Percentage in Excel using Formula?

Percentages are always calculated on per hundred bases. That means per hundred what is the proportion. We need two kinds of numbers one is the numerator and another one is the denominator. We always dived the numerator by the denominator and multiply the result by 100 to get the percentage value.

For example: Assume you were on vacation for 15 days and you have spent 10 days in your hometown and remaining 5 days in the USA. What is the percentage of days you have spent in the USA?

Here the total number of vacations is 15 days. It is split into two parts one is 10 days in hometown and 5 days in the USA.

  1. The excel formula for percentage is Portion Days / Total Days * 100.
  2. Percentage of Days spent in USA = 5 / 15 * 100 = 33.33%
  3. Percentage of Days spent in Home Town = 10 / 15 * 100 = 66.66%

1. First, enter a decimal number.

Decimal Number

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

Percentage Format

Result.

Percentage in Excel

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 (=).

Division Formula

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

Percentage Format

Result.

Percentage of Total

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

Increase Decimal

Result.

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.

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

20 Percent

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.

Percentage Increase

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 Decrease

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.

Old and New Number

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

Calculate Difference

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

Decimal Value

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.

Percentage Format

Result.

Percentage Change

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

Negative Percentage Change

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

Leave a Reply

Your email address will not be published. Required fields are marked *