How To Calculate Percentage Of Percentage In Excel?

Multiply the two percentages as decimals

Formula: `=A1*B1`

If A1 contains 20% and B1 contains 30%, the result is 6%

To find 20% of 30%, use `=20%*30%`

To calculate a percentage of a percentage from values entered as numbers, divide by 100 first

Formula: `=(A1/100)*(B1/100)`

Format the result cell as Percentage if needed

To get the final percent from a base value and a percent increase, use `=Base*(1+Percent)`

To get the final percent from a base value and a percent decrease, use `=Base*(1-Percent)`

Suggested for You

Trending Today