Office
Sign in

Calculate percentages

Sometimes percentages can be frustrating because it’s not always easy to remember what we learned about them in school. Let Excel do the work for you – simple formulas can help you find the percentage of a total, for example, or the percentage difference between two numbers.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

Find the percentage of a total

Say that your company sold $125,000 this quarter, and you need to find out what percentage $20,000 is of the total.

  1. To find out, divide $20,000 by $125,000. Here’s the formula in cell C2: =B2/A2. The result is shown as 0.16 because cell C2 is not formatted as a percentage.

    $125,000 in cell A2, $20,000 in cell B2, and 0.16 in cell C3

  2. To format 0.16 as a percentage, (which will also remove the zero) on the Home tab, click the Percentage button.

    If you are using Excel Online, click Home > Number Format > Percentage.

    Percentage button on the Home tab

    Now we see that $20,000 is 16% of $125,000.

    $125,000 in cell a2, $20,000 in cell b2, and 16% in cell c2

    Tip:  Formatting is the key to getting answers shown in percentages. Find out more in displaying numbers as percentages.

Find the percentage of change between two numbers

A company sold $485,000 in 2011 and $598,634 in 2012. What’s the percent change between the two years?

  1. First, click in cell B3 to apply the Percentage format to the cell. On the Home tab, click the Percentage button.

    If you are using Excel Online, click Home > Number Format > Percentage.

  2. In cell B3, divide the second year’s sales ($598,634.00) by the first year ($485,000.00), and then subtract 1.

    $485,000 in cell A2, $598,634 in cell B2, and 23% in cell B3, the percentage of change between the two numbers

  3. Here’s the formula in cell C3. =(B2/A2)-1. The percentage of change between the two years is 23%.

    Notice the parentheses around (B2/A2). Excel calculates what’s in parentheses first, and then subtracts the 1.

See also

Multiply by a percentage

PERCENTRANK function

Calculate a running total

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. Click 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, click  Percent Style button .

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

    Note: To change the number of decimal places that appear in the result, click 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

Let's say that 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. Click 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, click  Percent Style button .

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

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

Calculate a percentage of decrease

  1. Click 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, click  Percent Style button .

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

    Note: To change the number of decimal places that appear in the result, click 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. Click 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. In Excel 2016 for Mac:

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

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

    In Excel for Mac 2011:

    On the Home tab, under Number, click Currency  Currency button

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

    Note: To change the number of decimal places that appear in the result, click 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

Let's say that 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. Click 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. In Excel 2016 for Mac:

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

    In Excel for Mac 2011:

    On the Home tab, under Number, click Currency  Currency button

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

    Note: To change the number of decimal places that appear in the result, click 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

Let's say that 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. Click 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. In Excel 2016 for Mac:

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

    In Excel for Mac 2011:

    On the Home tab, under Number, click Currency  Currency button

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

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

Decrease a number by a percentage

  1. Click 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. In Excel 2016 for Mac:

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

    In Excel for Mac 2011:

    On the Home tab, under Number, click Currency  Currency button

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

    Note: To change the number of decimal places that appear in the result, click 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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×