The percentage increase between September and October is **25%**with this figure displayed as a decimal number (**0.25**) by default in Excel using the formula above.

If you want to display this figure as a percentage in Excel, you’ll need to override your cell formatting. Select your cell, then click the **Percent Style** in the **home **tab under **Number**.

You can also right click on your cell, click **Format Cells**then select **percentages** from the **Category > Number** to achieve the same effect.

## Calculation of percentage decrease in Excel

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

Continuing with the previous example, if a household bill is **$125** in October, but returns to **$100** in November, you would use the excel formula **=SUM(NEW-OLD)/OLD** or, in this example, **=SUM(100-125)/125**.

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

The difference between the figures for October and November is **twenty%**. Excel displays this as a negative decimal number (**-0.2**) in cells **B7** Y **B8** on.

Set cell number type to **percentages** using the **Home > Percentage Styles button** will change the decimal place (**-0.2**) to a percentage (**-twenty%**).

## Calculate a percentage as a proportion of a number

Excel can also help you calculate a percentage as a ratio. This is the difference between a number, as its whole digit, and a smaller number. This requires an even simpler mathematical calculation than a percentage change.

To give you an example, if you have a debt of **$100,** and you have already paid **$50**then the proportion of the debt that you have paid off (and coincidentally still owe) is **fifty%**. To calculate this, you **divide 50 by 100**.

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

This uses just a basic division operator to give you the decimal number (**0.5**).

Convert this type of cell number to **percentages** clicking **Home > Percentage Style button** will show the correct percentage of **fifty%**.

## How to calculate percentages of a number

Calculating the percentage of a number is something you will encounter in everyday life. A good example would be an item for sale, where a discount of **twenty%** is being applied to the original price of **$200**. A store clerk would need to know how much 20% of $200 was. They could then subtract this number from the original price to get the discounted price.

This requires another simple mathematical calculation in Excel. Only the multiplication operator (*****) and percent sign (**%**) are used here. to calculate that **twenty% **of the original **$200** the price is, you can use any **=20%*20****0** either **=0.2*200** to calculate in Excel.

To use cell references, where **twenty%** is in the cell **B4 **and the original price of **$200** is in the cell **B5**you could use the formula **=B4*B5**.

The result is the same whether you use **twenty%**, **0.2**or separate cell references in your formula. **20% of $200** It does not matter **$40**as shown in cells **B6 to B8 **on.

## Using Excel for Complex Calculations

As this guide shows, Excel is great for simple calculations, but it also handles more complex calculations. Calculations using functions such as the VLOOKUP function are made easy with the built-in function lookup tool.

If you’re new to Excel, take advantage of some Excel tips every user should know to further improve your productivity.