Comments on: How to divide in Excel and handle #DIV/0! error

As with other basic math operations, Microsoft Excel provides several ways to divide numbers and cells. Which one to use depends on your personal preferences and a particular task you need to solve. Continue reading →

Comments page 2. Total comments: 69

  1. I want to divide my following numbers on the same column take for example, Total Items is 100 and I have 7 scores of the following (85,80,95,60,78,58,87). Total percentage is 15%
    First student = total items 100 is on B4 and his score is 85, (85/100) * 100 * 0.15 = 12.75
    Excel Formula: =(B6/B4) * 100 * 0.15
    Now I want to drag down my formula but it became different. As soon as I drag down, the dividend became different.
    Excel Formula: =(B7/B5) * 100 * 0.15
    This cause me to gave an error result to my solution

  2. Is there a way to divide a set of numbers by the amount of data points selected? For example if I put data into 5 different cells I want a formula that will add those 5 numbers together then divide by 5 for an average. If I were to add another data point then it would add the 6 numbers together and divide by 6. Or do I just have to do this manually? TIA

    1. Hello Cody!
      I recommend making your data into a table. The table will automatically resize when you add data. Read here how to do it.
      You can then use the table data in formulas as described in this article.

      I hope my advice will help you solve your task.

  3. Formula to add the contents of B1 to B5 and divide the sum by contents of C7.

  4. I'm trying to divide my social media as follows, I want to get the reach and divide it by my the sum of comments, likes, and shares.

    So ideally the formula would be like this, if my reach is 1000 and my comments are 15, likes are 5, and shares are 15 I would like for these to be added together and then have the 1000 value divided by that sum.

    Hope that makes sense

    1. Hello Ivan!
      If I got you right, the formula below will help you with your task:

      =IF(AND(A1>=1000,B1>=15,C1>=5,D1>=15),1000/(A1+B1+C1+D1),0)

      Hope this is what you need.

  5. Hi,
    Can someone explain to me how can I divide one number equally into more cells?
    This is to do with eBay sales. I have 25 items and I want to create different listings like people having the option to buy 1, 2, 3, 5, and I want to divide the 25 in like (2x5=10) remaining 15 (2x3=6) remaining 9 3x2=6 remaining 3x1. I hope it makes sense.

    Thank you.

  6. How will i divide a number and put the quotient into multiple cells 3 to four cells, quotient should be a whole number.

  7. How to multiply (1.84+1.86)/2*(1.46+1.44)/2 in excel

  8. how to use divided formula in name and amount please said the formula

  9. =E5/E6
    Iska write formula kya hoga sir

  10. Good. Thank you.

    1. Most Welcome

  11. The "Divide a column by the same number with Paste Special" was extremely helpful, thank you!

  12. quite useful , thank you

  13. formula of division in excel

  14. please be note that i want to divide one column and drag to divide all the column with same formula please help me now

  15. 951 - 10 3639769 #VALUE!

  16. =(A1-B2)/B2 the answer should be in %
    for ex
    (10-0)/0 =100%

    1. Click on Percent Style under Number group in Home Tab. 2nd way that Press (Ctrl+Shift+%)

  17. =SUM(BO3,BP3,BR3)-MIN(BO3,BP3,BR3)

    i want to divide it by 2

    1. Arpa:
      Try =SUM((BO3,BP3,BR3)-MIN(BO3,BP3,BR3))/2

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)