While working with large **Microsoft Excel,** sometimes we need to** calculate percentages**. Some percentage is positive whereas some are negative. We can denote the negative percentage as the minus percentage. We can easily do that by using **Excel **formulas and **VBA Macros** also. This is an easy and time-saving task also. Today, in this article, we’ll learn **two **quick and suitable ways to calculate minus percentage in **Excel **effectively with appropriate illustrations.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

## Introduction to Percentage Decrease

While **subtracting** the second value from the first value, you will get the change between these two values. If the first value is less than the second value, you will get a **negative value.**

`Decrease = First value - Second Value`

Then divide this decreased value by the first value and multiply by 100, you will get the** percentage decreased**.

`Minus Percentage = (Decrease / First value)*100%`

## 2 Suitable Ways to Calculate Minus Percentage in Excel

Let’s assume a scenario where we have an **Excel **file that contains information about various types of input numbers. From our dataset, we will calculate the minus percentage by using the **mathematical** formula and **VBA Macros **also. Here’s an overview of the dataset for our today’s task.

### 1. Use Mathematical Formula to Calculate Minus Percentage in Excel

We can easily calculate the minus **percentage** by using the mathematical formula in excel. This is a time-saving way also. From our dataset, we will calculate the minus percentage. Let’s follow the instructions below to calculate the minus percentage!

**Step 1:**

- First of all, select cell
**D5**.

- Hence, write down the below mathematical formula in the selected cell. The mathematical formula is,

`=B5-C5`

- Further, press
**ENTER**on your keyboard and you will get**-20**as the difference between the two values.

**Step 2:**

- After that, select cell
**E5**and type a new mathematical formula. The formula is,

`=D5/B5`

- After typing the mathematical formula, again press
**ENTER**on your keyboard and you will get**-0.67**as the output of the mathematical formula.

**Step 3:**

- we will convert the fraction value into a percentage. To do that, from your
**Home**tab, go to,

**Home → Number → Percentage**

- Finally, you will get your desired output in cell
**E5**which has been given in the below screenshot.

**Read More:** **Subtract a Percentage in Excel (Easy Way)**

**Similar Readings**

**How to Calculate Dividend Growth Rate in Excel (3 Methods)****How to Use Profit and Loss Percentage Formula in Excel (4 Ways)****Percentage Difference between Two Percentages Excel (2 Easy Ways)****Calculate Year over Year Percentage Change in Excel (3 Easy Techniques)****Calculate Percentage Increase between 3 Numbers in Excel**

### 2. Run a VBA Code to Calculate Minus Percentage in Excel

Now I’ll show how to **calculate minus percentage** in Excel by using a simple **VBA **code. It’s very helpful for some particular moments and a time-saving way also. From our dataset, we will **calculate minus percentage.** Let’s follow the instructions below to **calculate minus percentage**!

**Step 1:**

- First of all, open a Module, to do that, firstly, from your
**Developer**tab, go to,

**Developer → Visual Basic**

- After clicking on the
**Visual Basic**ribbon, a window named**Microsoft Visual Basic for Applications – Percentage Decrease**will instantly appear in front of you. From that window, we will insert a module for applying our**VBA code**. To do that, go to,

**Insert → Module**

**Step 2:**

- Hence, the
**Percentage Decrease**module pops up. In the**Percentage Decrease**module, write down the below**VBA**Code.

```
Sub Percentage_Decrease()
Worksheets("VBA").Range("D5").Value = "=(((B5-C5)/(B5))*100%)"
End Sub
```

- Hence, run the
**VBA**To do that, go to,

**Run → Run Sub/UserForm**

**Step 3:**

- After running the code, go back to your worksheet, you will be able to calculate the minus percentage which has been given in the below screenshot.

**Read More:** **How to Calculate Percentage Decrease in Excel (2 Methods)**

## Things to Remember

👉 **#DIV/0!** error occurs when the denominator is **zero(0)**.

👉 If a **Developer **tab is not visible in your ribbon, you can make it visible. To do that, go to,

**File → Option → Customize Ribbon**

👉 You can pop up **Microsoft Visual Basic for Applications **window by pressing **Alt + F11** **simultaneously**.

## Conclusion

I hope all of the suitable methods mentioned above to **calculate the minus ****percentage** will now provoke you to apply them in your **Excel **spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

**Related Articles**

**Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Annual Growth Rate in Excel (3 Methods)****How to Forecast Growth Rate in Excel (2 Methods)****How to Add Percentage to Price with Excel Formula (2 Ways)****Calculate Revenue Growth Rate in Excel (3 Methods)****How to Calculate Accuracy Percentage in Excel (3 Methods)**