How to calculate percentage of a number in excel

Calculating percentages in Excel is easy. Percentage simply means 'out of 100', so 72% is '72 out of 100' and 4% is '4 out of 100', etc.

Enter a Percentage

To enter a percentage in Excel, execute the following steps.

1.

First, enter a decimal number.

2. On the Home tab, click the percentage symbol to apply a Percentage format.

Result:

Note: to change the percentage in cell A1, simply select cell A1 and type a new percentage (do not type a decimal number).

Percentage of Total

To calculate the percentage of a total in Excel, execute the following steps.

1.

Average and percentage formula in excel

Enter the formula shown below. This formula divides the value in cell A1 by the value in cell B1. Simply use the forward slash (/) as the division operator. Don't forget, always start a formula with an equal sign (=).

2.

On the Home tab, click the percentage symbol to apply a Percentage format.

Result:

3. On the Home tab, in the Number group, click the Increase Decimal button once.

Result:

Note: Excel always uses the underlying precise value in calculations, regardless of how

how to put percentage formula in excel

how to do an excel formula for percentage