How Do You Work Out Percentages in Excel?

How Do You Work Out Percentages in Excel?

How Do You Work Out Percentages in Excel?

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.