How do you work out percentages in Excel?

By Forinfos - 20/01/2026 - 0 comments

To calculate percentages in Microsoft Excel, click the Percent Style button to display the result as a percentage. Use formulas to calculate amounts, percentages and totals.

  1. Display the result as a percentage

    Click the Percent Style button in the Formatting toolbar. The button looks like the "%" symbol.

  2. Calculate the amount with the total and the percentage

    If you know the total and the percentage, find the percentage amount of the total by typing "=A2*B2," where "A2" and "B2" are the cells containing the total and the percentage.

  3. Calculate the percentage with the total and the amount

    Type "=A2/B2," where "A2" is the cell containing the amount, and "B2" is the cell containing the total.

  4. Calculate the total with the amount and the percentage

    Type "=A2/B2," where "A2" is the cell containing the amount, and "B2" is the cell containing the percentage.

Login to Comment

Comments

Be the first to write a comment for this article.

Related Articles

How do you work out percentages? How do you work out percentages without a calculator? How do I work out percentages on a calculator? How do you work out the percentage of something? How is a percentage increase worked out? How do you calculate percentage change in Excel? How do you subtract a percentage from a sum in Excel? How do you get percentages? What percentage of our lives are spent working? How do you get college credit for work experience?

Trending Articles

What are some of the most watched TV channels in Pakistan? What are some popular greeting card messages? What is the theme of "Freak the Mighty"? What are the cheers in the movie "Bring It On"? What power did Medusa have? What are some famous Urdu Sher pieces? Which radio stations play classic country music? What are some popular DVD releases for families? What are the highlights of the Mecum auctions in Kissimmee? What are some movies starring Kevin Bacon?