How to Calculate Reverse Percentage in Excel (4 Easy Examples)

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn how to calculate the reverse percentage in Excel. There are many times when we need to calculate the reverse percentage to find the original or initial value. We can calculate this reverse percentage in various ways. Today, we will use 4 examples to demonstrate the calculation of reverse percentage.


Download Practice Book

Download the practice book here.


What is Reverse Percentage?

In simple language, reverse percentage means calculating backward to find the original value, given a percentage of that value. Here, we must remember that the original value is 100% of the value. Suppose, 10% of a Number is 8. Then, the Original Number is 80.


4 Examples to Calculate Reverse Percentage in Excel

1. Calculate Reverse Percentage Manually in Excel

In the first example, we will learn to calculate the reverse percentage manually. For that purpose, we will use a dataset that contains the percentage of the total amount in the Percentage column and the Sales Amount represented by the percentage of some sellers. We will try to find the total sales amount of the sellers.

Calculate Reverse Percentage Manually in Excel

Let’s follow the steps below to learn this technique.

STEPS:

  • Select Cell E5 at first.
  • Now, type the formula:
=D5/C5

Calculate Reverse Percentage Manually in Excel

  • Then, hit Enter to see the result.

Calculate Reverse Percentage Manually in Excel

Here, the formula divides the sales amount by the percentage to get the total sales value.

  • After that, use the Fill Handle to see results in all cells.

Calculate Reverse Percentage Manually in Excel

  • Finally, you will see results like below.

Calculate Reverse Percentage Manually in Excel

Read More: How to Calculate Percentage Based on Conditional Formatting (6 Ways)


2. Compute Reverse Percentage to Obtain Original Price

In this example, we will calculate the reverse percentage to obtain the original price of some products when discounts are available. For explanation, we will use a dataset that contains the discounts in percentage and the current selling price of some products. We will use a formula to calculate the original price of the products.

Let’s observe the steps to know more.

STEPS:

  • Firstly, select Cell E5.
  • Secondly, type the formula:
=D5/(1-C5)

Compute Reverse Percentage to Obtain Original Price

  • Thirdly, press Enter to see the result.

Compute Reverse Percentage to Obtain Original Price

Here, this formula subtracts the discount from 1 and then divides the current selling by the subtracted result.

  • Finally, use the Fill Handle to see results in the rest of the cells.

Compute Reverse Percentage to Obtain Original Price

Related Content: How to Add 20 Percent to a Price in Excel (2 Quick Methods)


Similar Readings:


3. Determine Reverse Percentage in Excel to Find Initial Price

We will determine the initial price in this example. For that, we will use a dataset that contains the change in percentage and the current price of some products. Here, the change can be positive or negative. Positive change means the current price of the product is higher than the initial price. Similarly, negative change means the current price of the product is lower than the initial price.

Follow the steps below to know the procedure.

STEPS:

  • In the beginning, select Cell E5.
  • Next, type the formula below:
=D5/(C5+1)

Determine Reverse Percentage in Excel to Find Initial Price

  • Press Enter to see the result.

Here, the formula added the value of change with 1 and then divided the current price by it to find the initial price.

  • Lastly, drag down the Fill Handle to see results in all cells.

Read More: How to find percentage between two numbers in Excel


4. Excel MROUND Function to Calculate Reverse Percentage

We can use the MROUND Function to display the reverse percentage in a rounded figure. The MROUND Function returns a number rounded to the desired multiple. To explain this example, we will use the dataset of Example-1. Let’s follow the steps to know about the rounded reverse percentage.

STEPS:

  • In the first place, select Cell E5 and type the formula:
=MROUND(D5/C5,100)

  • Now, hit Enter to see the result.

Here, the MROUND Function first calculates the ratio of sales amount and percentage and then returns a number to the multiple of 100.

  • Finally, drag the Fill Handle down to see all the results.

If you see Cell E6 in the above dataset, you will notice the total sales value is different from the value we got in Example-1. We got $2,666.67 in the first example but $2700.00 in this example.

Related Content: How to Calculate Percentage Increase from Zero in Excel (4 Methods)


Things To Remember

When you are dividing a value with a percentage, excel first converts the percentage into a decimal number and then divides it. So, in the case of calculating the reverse percentage manually, you don’t need to multiply it by 100.


Conclusion

We have discussed 4 easy examples in this article to calculate the reverse percentage in excel. I hope these examples will help you to calculate the reverse percentage in all types of situations. Furthermore, the practice book is also added at the beginning of the article. So, you can download the practice book to exercise. Last of all, if you have any queries or suggestions, feel free to ask in the comment section.


Related Articles

Mursalin Ibne Salehin
Mursalin Ibne Salehin

Hi there! This is Mursalin. I am currently working as a Team Leader at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I manage and help the writers to develop quality content in Excel and VBA-related topics.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo