KEY CONTENT OF THE ARTICLE

How to Calculate Percentage increase or Decrease in Excel

if that visitors’re struggling of course calculating percentage increases or decreases in Microsoft Excel, This Problem guide will talk visitors through the process.

Microsoft Excel is perfect and wonderful and wonderful for basic and complicated calculations alike, including percentage differences. if that visitors’re struggling to calculate percentage increases or decreases on paper, Excel can do it for visitors.

if that visitors remember your school math, the process for calculating percentages in Excel is pretty similar. here’s how to qualifications Excel to calculate percentage increases and decreases. And perform other percentage calculations favorite percentages of a number.

## Calculating Percentage increase in Excel

Percentage increases involve two numbers. The basic mathematical approach for calculating a percentage increase is subtracting the second number from the first of all of all number. Using the sum of This Problem figure, divide This Problem remaining figure by the original number.

To give visitors an example, the cost of a household bill costs **$100** in September, but **$125** in October. To calculate This Problem difference, visitors could qualifications the excel formula **=SUM(generation-OLD)/OLD** or, for This Problem example, **=SUM(125-100)/100 **in Excel.

if that your figures are in separate cells, visitors can replace numbers for cell references in your formula. For example, if that September’s bill amount is in cell **B4** and October’s bill amount is in cell **B5,** your alternative Excel formula would be **=SUM(B5-B4)/B4**.

The percentage increase between September and October is **25%**, of course This Problem figure shown as a decimal number (**0.25**) by default in Excel using the formula above.

if that visitors want to display This Problem figure as a percentage in Excel, visitors’ll unexpected thing to replace the formatting for your cell. Select your cell, then click the **Percentage pattern** button in the **Home **tab, under the **Number** category.

visitors can also right-click your cell, click **Format Cells**, then select **Percentages** from the **Category > Number** menu to achieve with the catalyst.

## Calculating Percentage Decrease in Excel

To calculate the percentage decrease between two numbers, visitors’ll qualifications an identical calculation to the percentage increase. visitors subtract the second number from the first of all of all, then divide it by the first of all of all number. The only difference is that the first of all of all number will be smaller than the second number.

Continuing the above example, if that a household bill is **$125** in October, but it returns to **$100** in November, visitors would qualifications the excel formula **=SUM(generation-OLD)/OLD** or, in This Problem example, **=SUM(100-125)/125**.

Using cell references, if that October’s bill amount of **$125** is in cell **B4** and November’s bill amount of **$100** is in cell **B5**, your Excel formula for a percentage decrease would be **=SUM(B5-B4)/B4**.

The difference between October and November’s figures is **20%**. Excel displays This Problem as a negative decimal number (**-0.2**) in cells **B7** and **B8** above.

Setting the cell number type to **Percentages** using the **Home > Percentage Styles button** will change the decimal figure (**-0.2**) to a percentage (**-20%**).

## Calculating a Percentage as a Proportion of a Number

Excel can also help visitors calculate a percentage as a proportion. This Problem is the difference between one number, as your complete figure, and a smaller number. This Problem requires an even simpler mathematical calculation than a percentage change.

To give visitors an example, if that visitors bring a debt of **$100,** and visitors’ve already paid **$50**, then the proportion of the debt visitors’ve paid (and coincidentally still owe) is **50%**. To calculate This Problem, visitors **divide 50 by 100**.

In Excel, the formula to calculate This Problem example would be **=50/100**. Using cell references, where **$100** is in cell **B3** and **$50** is in cell **B4**, the excel formula required is **=B4/B3.**

This Problem uses only a basic division operator to give visitors the decimal number (**0.5**).

Converting This Problem cell number type to **Percentages** by clicking **Home > Percentage pattern button** will show the correct percentage figure of **50%**.

## How to Calculate Percentages of a Number

Calculating the percentage of a number is something that visitors’ll encounter in day-to-day daily life. A many years of experience example would be an item for sale, where a discount of **20%** is being applied to the original price of **$200**. A contain employee would unexpected thing to know what 20% of $200 was. They could then subtract This Problem number from the original price to provide the discounted price.

This Problem requires another merely mathematical calculation in Excel. Only the multiplication operator (*****) and percentage sign (**%**) are used here. To calculate what **20% **of the original **$200** price is, visitors can qualifications either **=20%*20****0** or **=0.2*200** to calculate in Excel.

To qualifications cell references, where **20%** is in cell **B4 **and the original price of **$200** is in cell **B5**, visitors could qualifications the formula **=B4*B5** instead.

The result is with the, whether visitors qualifications **20%**, **0.2**, or separate cell references in your formula. **20% of $200** equals **$40**, as shown in cells **B6 to B8 **above.

## Using Excel for Complex Calculations

As This Problem guide shows, Excel is perfect and wonderful and wonderful for merely calculations, but it handles again complex ones, too. Calculations using functions favorite the VLOOKUP function are produced easy, thanks to the built-in function search tool.

if that visitors’re generation to Excel, take advantage of some Excel tips every user should know to improve your productivity further.

### Bài viết cùng chủ đề

**Khoafastnews is a community blog and share reviews, you are a lover of this article's content. Please give us 1 Like, Share. Thank you.
Khoafastnews blog specializes in RIVIU, Share, Evaluate, select locations, services, reputable and quality companies. Place your ad here** chính thức.