How To Calculate A Percentage Of A Percentage In Excel?

Multiply the two percentages together

Convert each percentage to a decimal first

Use the formula `=A1*B1` if both cells contain percentages

Use the formula `=A1*B1/100` if one or both values are entered as whole numbers

Example: `20% of 50% = 0.2*0.5 = 0.1 = 10%`

Example formula in Excel: `=20%*50%`

Example formula using cell references: `=A1*B1`

Format the result cell as Percentage if you want the answer displayed as a percent

Suggested for You

Trending Today