Q:

How do you work out percentages in Excel?

A:

Quick Answer

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.

Continue Reading
How do you work out percentages in Excel?
Credit: Robert Daly OJO Images Getty Images

Full Answer

  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.

Learn more about Software

Related Questions

Explore