Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

Simple formulas can help you find the percentage of a total such as the percentage difference between two numbers.

Find the percentage of a total

Let's say that you answered 42 questions out of 50 correctly on a test. What is the percentage of correct answers?

  1. Select any blank cell.

  2. Type =42/50, and then press RETURN .

    The result is 0.84.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select   Percent Style button.

    The result is 84.00%, which is the percentage of correct answers on the test.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Find the percentage of change between two numbers

In this example, your earnings are $2,342 in November and $2,500 in December. What is the percentage of change in your earnings between these two months? Then, if your earnings are $2,425 in January, what is the percentage of change in your earnings between December and January? You can calculate the difference by subtracting your new earnings from your original earnings, and then dividing the result by your original earnings.

Calculate a percentage of increase

  1. Select any blank cell.

  2. Type =(2500-2342)/2342, and then press RETURN .

    The result is 0.06746.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Percent Style button.

    The result is 6.75%, which is the percentage of increase in earnings.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Calculate a percentage of decrease

  1. Select any blank cell.

  2. Type =(2425-2500)/2500, and then press RETURN .

    The result is -0.03000.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Percent Style button.

    The result is -3.00%, which is the percentage of decrease in earnings.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Find the total when you know the amount and percentage

Let's say that the sale price of a shirt is $15, which is 25% off the original price. What is the original price? In this example, you want to find 75% of which number equals 15.

  1. Select any blank cell.

  2. Type =15/0.75, and then press RETURN .

    The result is 20.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Click to set an accounting number format.

    The result is $20.00, which is the original price of the shirt.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Find an amount when you know the total and percentage

You want to purchase a computer for $800 and must pay an additional 8.9% in sales tax. How much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.

  1. Select any blank cell.

  2. Type =800*0.089, and then press RETURN.

    The result is 71.2.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Click to set an accounting number format.

    The result is $71.20, which is the sales tax amount for the computer.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Increase or decrease a number by a percentage

Consider the following.  You spend an average of $113 on food each week, and you want to increase your weekly food expenditures by 25%. How much can you spend? Or, if you want to decrease your weekly food allowance of $113 by 25%, what is your new weekly allowance?

Increase a number by a percentage

  1. Select any blank cell.

  2. Type =113*(1+0.25), and then press RETURN .

    The result is 141.25.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Click to set an accounting number format.

    The result is $141.25, which is a 25% increase in weekly food expenditures.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

Decrease a number by a percentage

  1. Select any blank cell.

  2. Type =113*(1-0.25), and then press RETURN .

    The result is 84.75.

  3. Select the cell that contains the result from step 2.

  4. On the Home tab, select  Click to set an accounting number format.

    The result is $84.75, which is a 25% reduction in weekly food expenditures.

    To change the number of decimal places that appear in the result, select Increase Decimal  Increase the number of decimal places or Decrease Decimal  Decrease the number of decimal places.

See also

PERCENTRANK function

Calculate a running total

Calculate an average

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.