Get total from percentage

★ 15 minutes read

Using MS Excel, you can easily find out the total of any given percentage. In order to get total from percentage, you must have a percentage that represents some part of the total amount. When you have the required data, you can easily find out the total by simply dividing the total amount by the given percentage.

Get total from the percentage

Formula

The general formula that is used to calculate total from percentage is as follows:

= total amount / percentage

Example 1

 

Figure 1. Get total from Percentage

Form the figure we can see that we have different amounts given for different expenses in the data. The percentage of the amount is also in the column D. we can easily calculate the total by dividing amount with percentage as shown in the figure.
In the above figure the formula used in E7 is:

= C7/ D7

Using this formula, the total is automatically calculated in the cell E7, which is $1,111.11

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar