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 ReadingClick the Percent Style button in the Formatting toolbar. The button looks like the "%" symbol.
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.
Type "=A2/B2," where "A2" is the cell containing the amount, and "B2" is the cell containing the total.
Type "=A2/B2," where "A2" is the cell containing the amount, and "B2" is the cell containing the percentage.