How to calculate percentage in Excel

34
41629
How to calculate percentage in Excel
Excel Spreadsheets

While some manage to do simple math calculations in their heads, many face difficulties when working with percentages. For both cases, the Excel can be a great facilitator in using percentages of larger numbers or also smaller operations that appear in the middle of a worksheet.

Basic excel and intermediate online courses

The important thing is to know that the calculation methods are exactly the same as what we would have to do on paper or on the calculator, however, in this case, we will use formulas from the program to facilitate the visualization of the information with references. Learn below how to calculate percentage in Excel:

Percentage

To begin, let's recall the concept of percentage: a comparison index between a value and a total.

How to calculate percentage in Excel 1

It is also possible to represent the number that is in decimal as a percentage, through the "Percentage Style" button, in the subgroup "Number" in the "Home" tab.

How to calculate percentage in Excel 2

Excel allows us to do any operation involving percentage, so let's see the practical application of some of the most common.

3 Rule

The 3 rule will follow the same rule as we normally use. In the example we will calculate how much percent represents the number 50 if the number 200 represents 100%.

How to calculate percentage in Excel 3

Difference of two numbers with percentage

Let's now calculate the percentage difference between 500 and 300.

How to calculate percentage in Excel 4

Using the formula we came to the conclusion that 500 is 67% greater than 300. This calculation is useful for comparing a company's expenses or revenues from one period to another.

Discount Calculations

We will calculate the total discount obtained based on the initial value of the product and the discount percentage granted.

How to calculate percentage in Excel 5

After this, we can calculate the amount paid, discounting the discount value of the initial value.

How to calculate percentage in Excel 6

And applying to all products.

How to calculate percentage in Excel 7

It is also possible to perform the calculation of the Payment Amount without the need to calculate the discount amount in advance, according to the following formula.

How to calculate percentage in Excel 8

Percentage operations are very diverse and can be used for a variety of purposes, but the basis for all is the same. So, from the given examples you will get the most out of Excel!

Basic excel and intermediate online coursesAre you in doubt? Get in on LUZ Excel Forum and send your question!

Excel Spreadsheets

34 COMMENTS

  1. Hi Maria, you need to use the SE function attached to the cell where it shows the seller's sales number. Something like = SE (A1> 12; 0,01; SE (A1> 7; 0,007; 0,005))

  2. Good afternoon,

    I'm trying to make a calculation more I do not know the correct formula,
    Eg our sellers receive on top of the sales value and quantity however 3 percentages exist.
    1 to 07 0,50%
    08 to 12 0,70%
    from 13 1,00%
    how would it look like it did 14 business worth 120649,00, I do not want to do so 120649,00 * 1%

  3. What formula to calculate type: column B is = the column Sometimes 12%?

  4. Hi Yen, assuming the payment amount is in A1 and the description was the view or installment in B2. The formula in C1 would be this:
    =se(B2=”Parcelado”;A1*(1-0,0089);se(B2=”A vista”;A1*(1-0,0149);A1)

  5. Hi Maria, in this case you need to tell Excel the order of operations. For example, if you want the percentage of 5% on top of the 10%, it would look like this = (30 * 0,9) * 0,95

  6. Good afternoon, taking advantage of that question. In this formula that you passed the value of the added percentages (for example, if I do it on the calculator, 30 - 10% - 5% of the 25,65 in excel is 30 -15% = 25,50 (even putting it separately)), you Can you tell me how do I get the percentages to appear one on top of the other?

  7. Hello good afternoon!
    I would like a formula to discount 1,49% when payment is in view and 0,89% when it is paid in installments. But always give the wrong value.

  8. I'm trying to get the average sales of the last 12 months and add 10% and I'm not getting it. = AVERAGE (B34: B45) + 10% Where am I going wrong?

  9. Hi Fabrício, I don't know if I understood it well, but to calculate how much a number represents from another, just divide one by the other. For example 68 represents 82,9% of 82 - the account is = 68/82 = 0,829

  10. Good Day!

    I have a doubt, my company is wanting to make a formula and I believe it is wrong, I'll explain what we need:

    - We sell tires, so we have a spreadsheet with the freight cost and the invoice amount, we want to know how many% the freight “occupies” in the bill.
    - To help me I will give you an example: Value Shipping R $ 68 - Value of the Note R $ 82 = what is the percentage that the freight represents in the note?
    - Second example would be: Freight Value R $ 57,02 - Note Value R $ 40 = What is the percentage it represents, remembering that the freight is greater than the value of the note.

  11. Hi Juliana, assuming 190 is in A1. In A2 you will write = A1 + (A1 * 1,2)

  12. Hi Junior, this will depend on the structure you are building. Assuming that the fleet values ​​are in cells A1: A5 and the quantity that left the day in B1: B5, then you can do for company 1 = B1 / A1 - that will be the percentage of cars that have left. To do the whole, just add and do the same division

  13. Good evening. I am a layman in formulas in Excel. I need help. I have 5 company names, and each company has a certain fleet of vehicles. I need to know on a given day the percentage of vehicles that took to the streets. Example: company A, fleet of 120 vehicles, left 70, what percentage they left? and so on, for each of the five companies. And in the end, the total fleet of 5 companies, example: 545, and the total percentage of how many vehicles came out, example 349. I can not create this in excel, even though it's apparently simple. Thank you.

  14. Good morning, I need to add 120% of the final value

    ex: 190,00 the final value, then I want a formula to add 120% on top of those 190. Can someone help me? in case I need the formula to give me the result of 418.00.

  15. Assuming x is in cell A1, it would be something like A1 - (A1 * 0,5) - (A1 * 0,1) - (A1 * 0,0682)

  16. Good afternoon, I have a question and I can not solve it.

    I need to use a formula that takes an X value and - 50% - 10% - 6,82% and has a final value, I broke my head here and I can't solve it

  17. Hi Odenir, how is this percentage calculated? By day or by the whole period? If it is for the period just multiply 75 by 0,02. If it is a day, for each day you will have to apply the percentage on the new value. In that case, you can use the future value formula if I'm not mistaken. Recall that for most operations, interest is compounded, so it is necessary to understand the range of variation and application of this percentage

  18. I need to calculate the 2% surcharge over a period of days. Eg value R $ 75,00 starting date in 03.07.2015. End date in 07.10.2017. Is it possible and easy to assemble, for those who are not very expert?

  19. I need the following calculation:
    I bought a discount 72,00 product from 30% when I put = (c2 * 30%) with the discount amount, but I need to calculate the final value, type = (72,00 * 30% less) =?

  20. is a single cell formula for x value - 39% + 5% + 60% possible? I made using several cells… one per operation…

  21. You can have a cell to calculate the number of existing processes in a given tab - it can probably be CONT.VALUES and then one to be the CONT.SE to analyze only the errors.

  22. I need to know if I had 10 processes in a company and 1 error. I know that efficiency is in 90%.
    But how do I calculate this in excel?

  23. Good afternoon! I would like to know if you have any formula to calculate percentage variable in excel?
    Example: 11,7% - (-2,6%) = 9,1% / 21,3% - (-9,8%) = 11,5%

  24. Hi Marcelo, how are you? Thanks for the compliment and for accompanying us. Unfortunately we do not accept comments with links that are unrelated to the post.

  25. We thank you for your compliments Cris, thank you and if you need anything you can count on us

Comments are closed.