Search results
People also ask
How to calculate percent in Excel?
How do I find the percentage of correct answers on a test?
What percentage is 11% in Excel?
Feb 26, 2024 · Learn how to use the basic percentage formula and the percentage increase formula in Excel with examples and tips. Also, find out how to format and present percentages in Excel with different decimal positions.
Mar 22, 2023 · Learn the basic percentage formula and a few more formulas for calculating percentage increase, percent of total and more. See how to use Excel functions such as SUMIF, SUMIFS and PERCENT to perform various percentage calculations.
- Svetlana Cheusheva
- Overview
- Find the percentage of a total
- Find the percentage of change between two numbers
- Find the total when you know the amount and percentage
- Find an amount when you know the total and percentage
- Increase or decrease a number by a percentage
- See also
- GeneratedCaptionsTabForHeroSec
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.
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 .
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.
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.On the Home tab, click .
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.On the Home tab, click .
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.
Learn how to use simple formulas to find the percentage of a total, the percentage of change, the original price, the sales tax, and more. See examples and steps for Excel for Microsoft 365, Excel for the web, and Excel 2021.
Learn how to calculate percentages, percentage of total, increase or decrease by percentage, and percentage change in Excel with simple formulas and examples. See how to apply percentage format and use division, multiplication, and subtraction operators.
- Calculate Percentage Using Basic Formula in Excel. There is no single formula for percentage which is applicable to every calculation. Although the basic principle is the same-to divide a partial value by the total value and multiply the result by 100.
- Find Percentage of Total Using Simple Formula. Let’s assume that we have a list of several mangoes and apples. We have to calculate the percentage of total mangoes and total apples in the proportion to the total number of fruits.
- Determine Percentage Difference Between Immediate Cells in a Column or Row. The excel formula for calculating the change between two values is: (New Value-Old Value)/Old Value.
- Calculate Amount and Total Value from Percentage in Excel. In a super shop, 20% of the fruits are mangoes. You can calculate the number of mangoes or the number of total fruits in the following way.
Aug 2, 2011 · Learn how to format values as percentages and use formulas to calculate percentages in Excel. See examples of discounts, percent change, and more.
Dec 26, 2023 · Learn how to use Excel percentage formulas to calculate percent increases, decreases, and amounts with step-by-step examples. Find out how to adjust the percentage value without rewriting the formulas and how to use functions for more flexibility.
