How to Calculate Percentage of Percentage in Excel (2 Examples)

Example 1 – Calculate the Percentage of Percentage from Raw Data

We have population data from a census where the percentages of Males and Children are provided separately. We’ll determine the number of male children in the population.

Steps:

Add a new column in column F for the results.

Enter the following formula in cell E5:

=C5*D5*E5

C5*D5= Population x Male Percentage = Male Population

(C5*D5)*E5= Male Population x Child Percentage = The number of boys in the population

Drag down the fill handle to complete the series.

We got the number of male children by using the percentage of a percentage.

Example 2 – Calculate the Percentage Increase or Decrease from Percentage Data

Steps:

We have a store’s monthly profit data where the percentage of increase or decrease is provided.
Calculate the amount of shared profit with the following formula in cell E5:

=C5*E5

Drag the fill handle down to get all the shared profits.

Determine the profit increase or decrease by entering the following formula in cell F5:

=(E6-E5)/E5

(E6-E5) = Profit increase or decrease

(E6-E5)/E5= Ratio of profit increase or decrease and initial profit

Drag down the fill handle.

How to Calculate the Average Percentage of Percentage in Excel

We have Voter numbers and Percentage of Votes in Favor from an election.

Compute the average proportion of votes cast in favor using the following formula:

=SUMPRODUCT(C5:C14,D5:D14)/SUM(C5:C14)

Formula Breakdown:

SUMPRODUCT(C5:C14,D5:D14)

SUMPRODUCT will multiply Voter Nos. in cell C5 with % Votes in Favor in D5 and continue the process up until 14th row after that the function will add up the products.

Output: 61628