Q:

# How do you work out percentages in Excel?

A:

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.

## Keep Learning

Credit: Robert Daly OJO Images Getty Images

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.

Sources:

## Related Questions

• A: To create a graph in Microsoft Excel, you must first input your data into the worksheet, then highlight it, and finally insert a chart by clicking the Inse... Full Answer >
Filed Under:
• A: Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represent... Full Answer >
Filed Under:
• A: The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is... Full Answer >
Filed Under:
• A: You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, ... Full Answer >
Filed Under:
PEOPLE SEARCH FOR