divided

  1. S

    split costs by overlap range dates

    Hello I have a list of costs to be divided for a list of users. Is it possible to allocate the costs, which the date range concerning, to users on the days of use? NB if in one day more users use the same service / cost, the cost must be divided by the number of users <html><head><title>Excel...
  2. I

    Loop to divide last cell in two different columns

    Hello, I'm trying to loop through a workbook and calculate the percentage between two values that are sums of their respective columns in each worksheet. I want to divide column Q last row value by R's last row value as well as T last row divided by R last row. My code is working, but the only...
  3. S

    Need to dynamically calculate based on returned value

    Hello Wizards, I'll explain this the best I can I'm developing a calculator in which the answer in D10 needs to be divided by a different number according to its value. Example If the answer is between 0-100 it would be divided by .5 101-200 divided by .501 201-300 divided by .502 etc How...
  4. S

    How to calculate expenses in a dynamic cash

    I have 4 columns for each partner. Contribution Expenses Balance %Balance In the second column (Expenses) I see the expenses that are being made and that should be divided among those people who have a contribution percentage (see the last column), and each one will spend based on that...
  5. C

    Five cell conditional division test formula

    Hi, I'm seeking assistance with the following: I have five cells, each with a single whole number ranging from 2 through 50. I'd like know if any of the five cells can be divided "equally" by one of the other four cells (no remainder). If this tests true, then a 'test column would be set to...
  6. mayday1

    Simple Formula error

    I've been staring at this too long and can't figure it out. When C2 is greater than 0, it gives me the value of E3*F3 plus E50*F50 (always above 0 if C2 is above 0). Why doesn't this formula divide by the value in cell C2? That value should be divided by C2, shouldn't it? =IF(C2>0,(('[UDR...
    • mayday1
    • Thread
    • 2019.xlsx]04-01$e$[udr blank divide divided formula
    • Replies: 3
    • Forum: Excel Questions
  7. R

    Divide result by 5

    I have this formula: =IFERROR(VLOOKUP($A8,[BannerAvails4.19.xlsx]Q2!$A$3:$FC$156,4,FALSE),"0") which produces the result I need. Now I need to modify it so that the resulting number will be divided by 5. Nothing I've tried seems to work. Any suggestions? Thank you in advance
  8. D

    Dividing a list into equal groups

    Hi I am a bit stuck with this and i need a bit of help I have a list of products that needs to be divided into equal groups by Weight and Order value. I cannot add the img tag so i just leave the link below: https://ibb.co/XLWk4Yb Thank you
  9. D

    Multiple Countifs

    I am attempting to calculate data from 3 tabs and its returning the incorrect %, essentially I am writing a statement that is 2 countifs the first divided by the second, here is the formula please help, I am open to a shorter formula as I'm sure I have overcomplicated mine...
  10. A

    Muliple criteria Using Frequency and Match Formulas

    Hello, I am trying to calculate the frequency how many of my students have responded in discussion boards. So first, I need to find a formula that will count the names excluding duplicates. I also want this formula to work if there are blank cells. Second, the students are all divided up between...
  11. G

    Sum of rounded values to equal original value

    Hi all, I have a random monetary value that is divided by a random number between 2 and 12. For example £6,992.00 divided by 6 = 6 equal amounts (after using the ROUND formula) of £1,165.33. I need the sum of the rounded instalments to always equal the original value (in this case £6,992.00)...
  12. M

    Difficulties With Formula

    Can someone please assist with this? If the value in column A="301", then sum column G, divided by, sum column K
  13. T

    Sumif

    Assume I have a column of data: 100 200 300 400 500 How can I create a SUMIF to sum, such that if each value divided by 10 is less than 5? Something like: =SUMIF((A:A)/10,"<5",A:A) Thanks
  14. S

    Need help with a calculation

    Hello! I have a question about a calculation, hoping somebody can help me. So I need a formula to have one number subtracted by another number, then it has to be divided by another number but that number that its being divided by is minus 1. The number that is being divided by will always be...
  15. C

    Nested IF statement with multiple criteria AND a range

    Hi all, Really hoping you can help with this one. I have a range of cells (J2:AH2) which all have one of 4 options in: Yes, No, Partially, or N/A. I want cell I2 to generate a 'score' based on the contents of the cells in the range. So: If any cell in the range = Yes, count 1, if Partially...
  16. Z

    Formula ?

    Trying to make this work. Trying to divide B6 cell into 2 then add B6 lets say B6 value is 50.78 trying to get 76.17 50.78 divided into 2 is 25.39 + 50.78 = to 76.17 =SUM(B6\B6)+(B6) Thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top