Percentage change in Excel

Percentage change in Excel
Last Updated on 07/05/2024
Reading time: 2 minutes

How do you calculate the percentage change between two periods?

  1. Subtraction between two consecutive periods

    Just subtract Month N minus Month N-1 (the newest minus the oldest)

  2. Divide the result by the oldest value

    Many people make mistakes in this area. You must divide by the oldest value, not the newest value.

When is it helpful to calculate the percentage of change with Excel?

Percentage change represents the relative change between two values, expressed as a percentage. It helps understand the degree of change over time or between different entities.

You have the following document with the total sales per month. How do we calculate the changes from one month to the next?

Percentage increase and decrease with conditional formatting

Percentage Calculation method

1. Subtraction between 2 months

The first thing to do is to see the difference between 2 consecutive months. The formula is straightforward

=B3-B2

Formula to calculate the gap between 2 cells

And, of course, you copy this formula for the other cells.

Copy the formula of the substraction

2. Divide the substation by the next month's value

To calculate the percentage of increase, we will

  1. Use the result of the subtraction
  2. Divide it by the sales amount of the previous month.

=C3/B2

Formula to calculate the percentage of increase or decrease

Apply the percentage format

Now, you must change the format number to percentage from the Home ribbon.

Percentaga number format

Copy the percentage formula for the rest of your document

Result percentage increase or decrease

Between February and March, the increase is up to 38.7% (great result 😃😍)

Write the formula in a single-cell

In mathematics, it's essential to respect the order of operations. Addition and subtraction do not have the same priority as multiplication and division. This is why, to perform the subtraction before the division, we must write the subtraction in parentheses.

=(B3-B2)/B2

The percentage formula in one single cell

Conditional formatting with icon

To highlight the increase and decrease, inserting icons with conditional formatting is a good idea.

Percentage increase and decrease with conditional formatting

Leave a Reply

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

Percentage change in Excel

Reading time: 2 minutes
Last Updated on 07/05/2024

How do you calculate the percentage change between two periods?

  1. Subtraction between two consecutive periods

    Just subtract Month N minus Month N-1 (the newest minus the oldest)

  2. Divide the result by the oldest value

    Many people make mistakes in this area. You must divide by the oldest value, not the newest value.

When is it helpful to calculate the percentage of change with Excel?

Percentage change represents the relative change between two values, expressed as a percentage. It helps understand the degree of change over time or between different entities.

You have the following document with the total sales per month. How do we calculate the changes from one month to the next?

Percentage increase and decrease with conditional formatting

Percentage Calculation method

1. Subtraction between 2 months

The first thing to do is to see the difference between 2 consecutive months. The formula is straightforward

=B3-B2

Formula to calculate the gap between 2 cells

And, of course, you copy this formula for the other cells.

Copy the formula of the substraction

2. Divide the substation by the next month's value

To calculate the percentage of increase, we will

  1. Use the result of the subtraction
  2. Divide it by the sales amount of the previous month.

=C3/B2

Formula to calculate the percentage of increase or decrease

Apply the percentage format

Now, you must change the format number to percentage from the Home ribbon.

Percentaga number format

Copy the percentage formula for the rest of your document

Result percentage increase or decrease

Between February and March, the increase is up to 38.7% (great result 😃😍)

Write the formula in a single-cell

In mathematics, it's essential to respect the order of operations. Addition and subtraction do not have the same priority as multiplication and division. This is why, to perform the subtraction before the division, we must write the subtraction in parentheses.

=(B3-B2)/B2

The percentage formula in one single cell

Conditional formatting with icon

To highlight the increase and decrease, inserting icons with conditional formatting is a good idea.

Percentage increase and decrease with conditional formatting

Leave a Reply

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