Excel Example – Percentage in Excel

Calculating percentage 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.

Decimal Number

2. On the Home tab, in the Number group, click the % symbol to apply a Percentage format.

Percentage Format

Result.

Percentage in Excel

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. 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 (=).

Division Formula

2. On the Home tab, in the Number group, click the percentage symbol to apply a % format.

Percentage Format

Result.

Percentage of Total

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

Increase Decimal

- Advertisement -

Result.

Percentage with One Decimal Place

Note: Excel always uses the underlying precise value in calculations, regardless of how many decimals you choose to display.

Increase by Percentage

To increase a number by a % in Excel, execute the following steps.

1. Enter a number in cell A1. Enter a decimal number (0.2) in cell B1 and apply a Percentage format.

20 Percent

2. To increase the number in cell A1 by 20%, multiply the number by 1.2 (1+0.2). The formula below does the trick.

See also  Excel Example - Multiply in Excel

Percentage Increase

Note: Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first.

3. To decrease a number by a %, simply change the plus sign to a minus sign.

Percentage Decrease

Percentage Change

To calculate the % change between two numbers in Excel, execute the following steps.

1. Enter an old number in cell A1 and a new number in cell B1.

Old and New Number

2. First, calculate the difference between new and old.

Calculate Difference

3. Next, divide this result by the old number in cell A1.

Decimal Value

Note: Excel uses a default order in which calculations occur. If a part of the formula is in parentheses, that part will be calculated first.

4. On the Home tab, in the Number group, click the % symbol to apply a Percentage format.

Percentage Format

Result.

Percentage Change

5. The (New-Old)/Old formula always works.

Negative Percentage Change

Note: visit our page about the percent change formula for a practical example.

Common Use Cases

  • Calculating grades: Determine the % of correct answers on a test.
  • Analyzing financial data: Calculate profit margins, growth rates, and changes in stock prices.
  • Tracking progress: Monitor progress towards goals by calculating the % of completion.
  • Applying discounts: Calculate discounts on products or services.

Additional Notes:

  • The result is displayed as a %, but you can adjust the number of decimal places if needed by clicking the “Increase Decimal” or “Decrease Decimal” buttons in the Home tab under the Number group.
  • If you want to format the result as a % directly, you can multiply the formula by 100 and use the % format for the cell.

By mastering these basic techniques, you can effectively use Excel to perform a wide range of % calculations.

See also  Excel Example - Quick Access Toolbar in Excel

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Stay in Touch

Stay in touch to boost your skills in Excel, HTML, and JavaScript! Get tips, tutorials, and practical examples to make your learning journey efficient, fun, and highly rewarding.

Related Articles