Comments on: Google Sheets percentage formulas - usage and examples

You may think percentage calculations are useful only if you use them for work. But in reality, they help you in everyday life. Do you know how to tip properly? Is this discount a real deal? How much will you pay with this interest rate? Come find the answers to these and other similar questions in this article. Continue reading →

Comments page 3. Total comments: 190

  1. need to calculate percentage markup

    row of cells: cost retail %markup

    need to multiply cost x100 then divide by retail? just can't figure out order

  2. Hi! thank you for this tutorial!

    You may be able to help me, I am doing a spreadsheet where I track my business profits on a daily basis.
    I already get my daily % growth, but I would like to do a TOTAL percentage, from my 1st day to today.
    The trick is that I want it to fill itself, and in only 1 cell. I want the result of this growth to always appear in the 'k5' cell, for example, and for it to always take the last input and the very 1st one without me having to change the formula every day.

    If you can help, I'll take it!
    Thank you very much.

    1. Hi Kuro,

      thank you for the feedback!
      I'm afraid I'll need more details on your data to help you out. Can you please describe where it's located in the spreadsheet in detail (Sheet? Column? The number of rows?) and give an example of how it looks?
      What formula do you use and what do you update in it constantly?

  3. My family and I have a weekly running nfl pool. Each week column input and results of course change. I use check boxes to say who wins and who loses and the sumif function at the end of the column to give me the needed results. I decided to test the workings of the sheet and everything works fine except for one thing. When I attempt to divide cells d22(total wins) with e22(total losses) To get the percentage needed I have used the formula =(D22+E22)/D22 which does not work. What am I doing wrong?

    1. Joseph,

      Could you please specify what are you trying to get? The percent of losses or wins from the complete total? Or something else?
      If it's possible, please also share your sample data with us (support@4-bits.com) and reply to my comment when we can take a look. Thank you.

  4. Hi,
    I'm trying to keep track of attendance using a google sheet with checkboxes. Here is the formula for what I have: =COUNTIF(C6:X6,"TRUE")/COUNTA(C6:X6,"FALSE")
    My issue is, if all of the boxes are checked, the percent should be 100% but it's only 95.65%.

    Any ideas?

    1. Hi Lisa,

      Would you mind sharing your sample data with us (support@4-bits.com) so we could have a look?
      Note. That email address' Inbox is unmonitored. Once you share the file, please confirm by replying here. Thank you.

  5. Hi,
    How to do calculate =a2*b2 for multiple cells ex:a2-a5*b2-b5 etc...

    1. Hi Matt,

      If I understand you correctly, this formula should do the trick:
      =ARRAYFORMULA(A2:A5*C2:C5)

  6. Why does google sheets add 2 zeros to my values when I try to apply the "percent" format?? I just want the % to appear next to the number already in the cell.

    1. Hello Diana,

      That's simply the way Google Sheets works.

      In your turn, you can adjust the number of zeros using the corresponding options from the Sheets toolbar. Look for two buttons with zeros right under the Format option: Decrease decimal places and Increase decimal places. The tip from this point of the article shows them.

  7. or do a vidio please

    1. Hello Tyler,

      Could you please specify what points of the article remain unclear?
      At the moment I don't believe the video would feature something other than the same formulas.
      If you could describe the task you're dealing with, I would gain a better understanding of what to improve.

      Thank you.

      1. Hey so I run a business and I pay my drivers 30% of the income. Lets say a driver makes on a week $4560 I need to pay 30% of that to him. Is there a formula that can help me find the value of that 30%? Thank you.

  8. Great stuff!

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)