Often you may want to calculate a reverse percentage in Excel.
For example, the value 48 is 75% of what number?
To calculate this by hand, you would simply do 48 / 0.75 = 64.
To perform this calculation in Excel, assuming 48 is in cell B2 and 75% is in cell C2, you could use the following formula:
This formula would return the correct value of 64.
The following example shows how to use this formula in practice.
Example: Calculate Reverse Percentage in Excel
Suppose we have the following dataset that shows the number of points scored in the first quarter by various basketball teams along with the percentage of total points that the first quarter points represent:
For example, the Mavs scored 25 points in the first quarter, which represents 20% of their total points scored in the entire game.
To calculate a reverse percentage, i.e. find the total number of points, we could perform the following calculation:
Total Points = 25 / 20% = 25 / 0.20 = 125
We can type the following formula into cell C2 to perform this calculation in our spreadsheet:
We can then click and drag this formula down to each remaining cell in column C:
Column D now displays the total points scored by each team.
- The Mavs scored 25 / 0.20 = 125 total points.
- The Spurs scored 40 / 0.25 = 160 total points.
- The Rockets scored 30 / 0.30 = 100 total points.
- The Kings scored 30 / 0.20 = 150 total points.
And so on.
The following tutorials explain how to perform other common tasks in Excel: