How To Set Percentage Formula In Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2010 Excel 2007 Excel for Mac 2022 More than...Less

Sometimes percentages can be frustrating considering it's not e'er easy to think what we learned nigh them in schoolhouse. Let Excel do the work for you – simple formulas can help yous find the percentage of a total, for instance, or the pct difference between two numbers.

Detect the percentage of a total

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

Click any blank prison cell.
Type = 42/50, and and then press Return .

The result is 0.84.
Select the cell that contains the issue from step ii.
On the Dwelling house tab, click .

The event is 84.00%, which is the percentage of correct answers on the exam.

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

Find the percentage of change betwixt ii numbers

Permit'southward say that your earnings are $two,342 in November and $2,500 in December. What is the per centum of modify 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 betwixt December and Jan? You tin can summate the difference by subtracting your new earnings from your original earnings, and then dividing the result by your original earnings.

Calculate a pct of increase

Click any bare cell.
Blazon = (2500-2342)/2342, and and then printing Render .

The result is 0.06746.
Select the cell that contains the result from step 2.
On the Home tab, click .

The effect is half-dozen.75%, which is the per centum of increase in earnings.

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

Calculate a percentage of decrease

Click whatever blank cell.
Blazon = (2425-2500)/2500, so press Return .

The result is -0.03000.
Select the cell that contains the result from step 2.
On the Habitation tab, click .

The issue is -iii.00%, which is the pct of decrease in earnings.

Annotation:To change the number of decimal places that announced in the result, click Increase Decimal or Subtract Decimal .

Find the total when you know the amount and percentage

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

Click any blank cell.
Type = xv/0.75, and then press RETURN .

The result is 20.
Select the jail cell that contains the event from step two.
In newer versions:

On the Home tab, click .

The effect is $twenty.00, which is the original toll of the shirt.

In Excel for Mac 2022:

On the Domicile tab, under Number, click Currency

The issue 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 or Decrease Decimal .

Find an amount when you know the total and percentage

Permit'due south say that want to buy a estimator for $800 and must pay an boosted 8.9% in sales taxation. How much do you have to pay for the sales taxation? In this example, you lot want to find 8.9% of 800.

Click any blank cell.
Type = 800*0.089, then printing Return.

The result is 71.2.
Select the jail cell that contains the result from pace 2.
In newer versions:

On the Home tab, click .

In Excel for Mac 2022:

On the Abode tab, under Number, click Currency

The result is $71.twenty, which is the sales tax amount for the reckoner.

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

Increase or decrease a number by a per centum

Let's say that you spend an average of $113 on food each week, and yous want to increase your weekly food expenditures by 25%. How much tin y'all spend? Or, if you want to subtract your weekly food allowance of $113 by 25%, what is your new weekly allowance?

Increment a number by a percentage

Click any blank jail cell.
Blazon = 113*(i+0.25), and then press RETURN .

The result is 141.25.
Select the cell that contains the consequence from stride 2.
In newer versions:

On the Home tab, click .

In Excel for Mac 2022:

On the Home tab, nether Number, click Currency

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

Note:To modify the number of decimal places that appear in the event, click Increment Decimal or Decrease Decimal .

Decrease a number by a percentage

Click whatever blank cell.
Type = 113*(1-0.25), and and so press RETURN .

The result is 84.75.
Select the prison cell that contains the result from stride 2.
In newer versions:

On the Dwelling house tab, click .

In Excel for Mac 2022:

On the Home tab, under Number, click Currency

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 or Decrease Decimal .