Companies always calculate the profit and loss on the sale of their products as a percentage and supply the products to the market accordingly. It also helps to visualize the comparisons among products. So it is important to know about the procedures of how to calculate percentage increase in Google Sheets.

**Table of Contents**hide

**A Sample of Practice Spreadsheet**

You can download the Google Sheets used to demonstrate methods in this article from here.

**4 Easy Methods to Calculate Percentage Increase in Google Sheets**

We will use the following sample dataset to demonstrate these methods accurately. The dataset represents the total sale of some fruits in January and February month of a fruit shop.

**1. ****Using Basic Mathematical Formula**

In the following dataset, we can see that the total sale of all products increased in February compared to January. We want to represent this growth as a percentage. We can use our basic mathematics to solve this and we can calculate this percentage increase in Google Sheets in 2 ways-

**1.1 Percentage Using Format**

Changing the format of the entire range of cells will automatically show the result as a percentage.

**Steps:**

- In the following dataset, we can see that the total sale of all products increased in February compared to January. We want to represent this growth as a percentage.

- First, select the entire
**Column E**. Then at the toolbar, select**Format**.

- Go to
**Number**and select**Percent**.

- The entire
**Column E**is now formatted as percent and it will show results as percentages now. - Select
**Cell E6**and type down the following basic formula that we use to calculate the total percentage increase-

`=(D6-C6)/C6`

- We can already see that the result showing in
**Cell E6**is as a percentage. Here the result 22.00% indicates that the total sale of Mango increased by 22% in February month compared to January. - Now simply drag down selecting the
**Fill Handle**icon as shown in the circled portion.

- And the total percentage increase of total sales for the other items will be calculated as well.

**1.2 Percentage Using Formula Only**

We can show the same using formula only rather than changing the format. Using this method will calculate the percentage increase but this will not show results as percentage. So that’s why we have used **(%) **notation at the heading.

**Steps**:

- Select
**Cell E6**and apply the following formula and press**Enter**. This will calculate the percentage increase directly.

`=(D6-C6)/C6*100`

** **

- Now simply drag down selecting the
**Fill Handle**icon as shown in the circled portion.

- And the total percentage increase of total sales for the other items will be calculated as well.

**2. ****Applying TO_PERCENT Function**

Previously what did we do? We calculated the difference between the new and older value that is the total sales in February minus the total sale in January and then divided that value by the older value that is total sales in January and multiplied the final result with 100 or formatted the entire cell range as percent in order to get the percentage increase. But if we use **the TO_PERCENT function** we don’t need to format the cell range also we don’t need to multiply by 100 as well.

**Steps:**

- In the following dataset select
**Cell E6**and apply the following formula and press**Enter**.

`=TO_PERCENT((D6-C6)/C6)`

- Now simply drag down selecting the
**Fill Handle**icon as shown in the circled portion like before.

- And the total percentage increase of total sales for the other items will be calculated and shown in
**Cell****range E7:E13**.

**3. ****Combining TO_PERCENT, DIVIDE and MINUS Functions**

We can do the whole calculation using arithmetic functions like **DIVIDE****, ****MINUS** as well. So here, we won’t need to insert the minus and division sign manually.

**Steps:**

- Select
**Cell E6**and apply the following formula-

`=TO_PERCENT(DIVIDE(MINUS(D6,C6),C6))`

** **

__Formula Breakdown__

**MINUS(D6,C6)**

This will subtract **Cell D6** to **Cell C6.**

**DIVIDE(MINUS(D6,C6),C6)**

This will divide the subtracted value by **Cell C6**.

**TO_PERCENT(DIVIDE(MINUS(D6,C6),C6))**

And this will represent the whole value as a percentage.

- Now simply drag down selecting the
**Fill Handle**icon as shown in the circled portion like before.

- And those functions will do the same for other cells also.

**4. ****Merging ARRAYFORMULA and IFERROR Functions**

The most annoying thing is to repeat tasks and not to get through this, we can use **the ARRAYFORMULA function**. Combining **ARRAYFORMULA** and **IFERROR** functions will result in the whole column at once.

**Steps:**

- First, select
**Cell E6.**Then apply the following formula below and press**Enter**.

`=ARRAYFORMULA(IFERROR((D6:D13-C6:C13)/C6:C13*100,0))`

** **

__Formula Breakdown__

**IFERROR((D6:D13-C6:C13)/C6:C13*100,0)**

Here, **the IFERROR** **function **will show the valid result if exists while calculating in **D6:D13-C6:C13)/C6:C13*100 **criteria and if no valid result exists then it will return **“0”**.

**ARRAYFORMULA(IFERROR((D6:D13-C6:C13)/C6:C13*100,0))**

The **ARRAYFORMULA** will help to get rid of repeated calculations for other cells.

**Conclusion**

In this modern world, we use charts, tables, graphs or percentages to visualize a topic simply. In many different contexts, percentages are frequently utilized. For instance, percentages are used to express discounts in stores, bank interest rates, inflation rates, and various statistics in the media. Understanding percentages is crucial to comprehending the financial aspects of daily living. In this article, we tried to demonstrate 4 easy methods on How to Calculate Percentage Increase in Google Sheets. Hope this will help you with your work. Our site **officewheel.com** surely will help you to become more efficient and expert in using Google Sheets.