# Calculate Percentages

# the Right Way in Excel

## (% Change & Amount after % increase)

Let’s look at calculating percentages.

Seem simple enough, but there may be few tricks we can use to ensure everything works smoothly and displays properly.

We will not only look at the formula to calculate a percentage change but also perform the calculation in a way that makes it easy to remember.

We will also look at formulas that allow us to calculate percentage increases and decreases.

For example, we have a price of $100 and we wish to increase that price by 15%. What will be our new price?

# Calculating Percentage Change

In the below example, we have list of products with their actual values and their related budget values.

Your job is to calculate the percentage change.

We will let “**A**” represent **Actual** and “**B**” represent **Budget.** Our formula will be **Actual** minus **Budget** divided by **Budget**.

Another way to write this is **Actual** divided by **Budget** minus **Budget** divided by **Budget**.

Which turns into **Actual** divided by **Budget** minus **1**.

In our sample file, we will select cell **D5** and enter the following formula:

=B5/C5-1

Fill the formula down the remainder of the table and apply a percent style to the results.

# Calculating Amount After % Increase

In our sample table, our starting price is in column **A** and we wish to increase or decrease by a defined percentage located in column **B**.

Letting “**P**” represent **Price,** our formula will be **Price** plus **Price** times **Percentage**.

This can alternately be written as **Price** times **1** plus **Percentage**.

In our sample file, we will select cell **C3** and enter the following formula:

=A3*(1+B3)

Since our starting price was **$100** and we increased the price by **10%**, the resultant price is **$110**.

# Entering Percentages in Excel

When entering in a percentage value in Excel, it is common to type the number followed by a percent sign. Excel will automatically apply the Percentage style when it detects this input pattern.

Another option is to enter the value as a decimal and then manually apply the Percentage style to the entered value.

Another technique is to apply the Percentage style to the cell prior to entering the value.

The user can enter their number as if it were a whole number, but it will be perceived as a percentage (i.e. 30 becomes 30%)

*WARNING: Do not take values that have been entered as whole numbers and apply the percentage style expecting to get a percentage of 1. Example: If you the value “30” and then apply the Percentage style to the value, you will not receive “30%” but instead you will receive “3000%”.*

## Practice Workbook

Feel free to Download the Workbook HERE.

LWFebruary 26, 2019 at 3:08 amHi, this really useful but what if the divisor is 0. it will return and error, wehs hd get a 100% increase.

Leila GharaniMarch 5, 2019 at 8:23 amYou can use IFERROR to handle error values or an IF statement to define the specific outcome you’d like to have if the divisor is zero – more on IF function here: https://www.xelplus.com/excel-if-formula-simple-to-advanced/

ADAMSeptember 19, 2019 at 11:43 amVERY HELP FULL THANKS MADAM