Contents

How to Calculate Percentage Decrease (3 Easy Ways)

March 28, 2025 89 views

Whether you're working on finances, analyzing sales data, or simply trying to track reductions in various metrics, understanding how to calculate percentage decreases is vital. This article details three efficient methods to calculate percentage decreases: manually, using Excel, and in WPS Office. Whether you're a beginner or a pro, these techniques simplify your workflow and enhance accuracy in tracking reductions.

Part 1: How to Calculate Percentage Decrease Manually

You need to use a simple formula to calculate a percentage decrease manually. Here's a well-crafted step-by-step guide to help you get hold of this process:

Step 1: Identify the Old and New Values

The first step is to determine the starting value, the original value, and the reduced value, also known as the final value.

For instance, if you're finding the price of a product that has decreased from $125 to $95, $125 is the old value, and $95 is the new value.

Step 2: Subtract the New Value from the Old Value

The next step is subtracting the new value from the old value to calculate the difference.

Formula:

Decrease = Old Value - New Value

Example: 125 - 95 = 30

This is the decrease in value.

Step 3: Divide the Decrease by the Old Value

Determining the percentage decrease involves dividing the decrease value by the old value.

Formula:

Decrease ÷ Old Value = Decimal

Example: 30 ÷ 125 = 0.24

Step 4: Multiply the Result by 100 to Get the Percentage

Lastly, convert it into a percentage and multiply the result by 100.

Formula:

Decimal × 100 = Percentage

Example: 0.24 × 100 = 24%

Result: The percentage decrease is 24%.

After using this method for a long time, I found it straightforward and suitable for beginners. The process doesn't require special tools, just basic math, making it quite simple. I recommend this method for those who prefer a hands-on calculation approach or when Excel isn't available.

100% secure

Part 2: How to Use Excel Functions to Calculate Percentage Decrease

Method 1: (Old Value - New Value) / Old Value

This method is simple as it uses a straightforward formula directly in Excel.

Step 1: Enter the old value in one cell (e.g., A1) and the new value in another (e.g., B1).

Step 2: In a third cell (i.e., C1), enter the formula:

= (A1 - B1) / A1

This will auto-calculate the percentage decrease.

Step 3: To format the result as a percentage, right-click the cell, select "Format Cells," and choose the "Percentage" option.

Once you understand this method in Excel, it becomes very efficient. It is a great asset because it eliminates manual calculations, saving time, especially when working with large datasets. It's excellent for anyone using Excel for financial work or data analysis.

Method 2: Old Value / New Value - 1

You can use an alternative formula in Excel to calculate the percentage decrease.

Step 1:

Enter the original value in one cell (i.e., A1) and the final value in another (i.e., B1).

Step 2: In the third cell (i.e.., C1), enter the formula:

= A1 / B1 - 1

Step 3: You can format the result as a percentage by right-clicking the cell, selecting "Format Cells," and then choosing "Percentage."

This effective method provides an easy way to calculate the percentage decrease. It benefits more seasoned Excel users, as it requires a slightly different approach, but its accuracy is unmatched. It's best for anyone and everyone who needs to apply this formula efficiently across several rows.

Comparison of Methods:

Given the above information, both Excel methods are effective and can be used interchangeably. For beginners, the first method feels more intuitive. In contrast, the second method can be helpful for more complex calculations or when dealing with ratios, hence needing a bit of deep understanding.

The ability to easily copy these formulas across several rows is a significant advantage for large datasets.

100% secure

Part 3: How to Convert Numbers into Percentages in WPS Office

WPS Office is a free office suite alternative to Microsoft Office. It allows you to calculate percentage decreases and convert numbers to percentages easily.

Step 1: Enter the original and final values into two separate cells, i.e., A1 and B1.

Step 2: In a third cell, enter the formula for percentage decrease, just like the one in Excel:

= (A1 - B1) / A1

Step 3: To display the result as a percentage, highlight the result cell, right-click, select "Format Cells," and choose "Percentage."

WPS Office is a great free alternative to Excel. Converting numbers to percentages is similar to Excel's, making it seamless for users familiar with spreadsheets. I recommend WPS for individuals who don't have access to Excel but still need powerful spreadsheet tools or equal experience. It's user-friendly and great for personal or small business use.

FAQs

Q1: Why do Excel and WPS display results as decimals?

Excel and WPS Office initially display results as decimals because these programs compute raw mathematical results. You need to format the cells as percentages to show the results as percentages. To do this, right-click the result cell, select "Format Cells," and then choose the "Percentage" format. This converts the decimal into a readable percentage.

Q2: How do you apply percentage decrease formulas to multiple rows in Excel?

Use the AutoFill feature to apply a percentage decrease formula to multiple rows. After entering the formula in the first row, click the bottom-right corner of the cell and drag it down to fill it in the other rows. This allows you to apply the formula across all the rows without manually entering it for each one.

Summary

This article explored three practical ways to calculate percentage decrease: manually, using Excel formulas, and through WPS Office. Each method offers unique benefits depending on your tools and preferences. Mastering Excel's built-in functions can save you time if you frequently work with spreadsheets. WPS Office provides an excellent solution for those looking for a free alternative. Your chosen method will depend on your needs, whether you're handling small calculations or large datasets.

100% secure

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.