Percentage formula in excel multiple cells

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.

Enter the formula shown below.

Percentage formula in excel sheet download

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 take percentage formula in excel

how to do percentage increase formula in excel