1. T

    Monthly payment calculator

    I'm looking to break down a total charge into monthly payments. B2 contains the total charge B3 contains the number of monthly payments B5 contains the first instalment B6 contains the remainder This would be simple if the amounts were spread evenly, but I want to make sure that any pence are...
  2. S

    Formula in excel

    I think I need to use an IF formula but can’t work it out. I have F4+E4 to give me the G4. So i have a few different hours so I need the formula so that if G4 is equal to or greater then 8 then the remainder hours calculate to multiply by 1.5 Can anyone help please?
  3. M

    Splitting a number in a cell into 2 smaller numbers

    Hi all , in cell B56 i have 13,857 which is a sum of B2:B53 and im looking to split this down into 10,000 into cell B58 then the remainder into cell B59 . Any ideas on what function i would use to do this? Thanks!
  4. J

    How to: Proportionally Distribute Remainder

    Hi, I have a budgeting app that is missing a feature, so I need to perform this calculation manually. I would like to have excel do it for me if possible. Is there a way to distribute a remainder proportionally across the separate categories? In the sample below I need to divide 1.26 among the...
  5. M

    Subtract n from min value and then remainder of n from max value

    As the title says, I want to subtract n from min value first and then the remainder of n from the max value. I thought I had it cracked until one of the values exceeds n. My formula is =IF(C4=D4,C4-(B/2),IF(C4<D4,MIN(SUM(C4:D4)-B4,0),MAX(SUM(C4:D4)-B4,0))) for bot AA and BB...
  6. B

    mod(186,6) return 6, not 0

    Hi, I used mod function to get remainder for 246. =IF($M2<>0,IF($M2>60,$M2+IF(MOD($M2-60,6)>0,6,0),60),0) I used above formula in column N. Column M has formula too. If M2 has bigger than 60, then minus 60, and then divide by 6. IF remainder exist, then add 6, or add 0. M2 was 246, and N2...
  7. D

    Recommendations on Protecting/Locking a column

    I have a situation where I have a composite column that has a very specific and in depth formula that I do not want anyone to have the ability to accidently alter and am looking for suggestions on best practices to keep this column so only I have control over it. With that said I still need the...
  8. F

    Subtracting until zero then taking remainder from another cell.

    Hi all, I am having a problem thinking of formula to calculate my wine stock with Excel 2013. Here is an example: <tbody> Wine Name Opening Stock Bottles Total Sales Closing Stock Glass Bottle Total Received Glass Bottle total Glass Bottle total Wine 1 0.0 1.0 1.0 0.0 1.0 0.4 0.0 0.6...
  9. P

    Stop writing cells at row 50 and wrap the remainder of the text to the next columns

    I am a novice user of excel, at best, however, my spreadsheet has 85 rows of data in columns A, B, and C. I want to write the rows of data from rows 1-50 in A, B and C and from rows 51-85, I want to write in row 1 and following the remainder of the data in columns D, E and F. Please help!
  10. D

    Change remainder to whole number?

    I want to basically be able to use the remainder as a whole number. So I may have a problem that is 277/10 = 27.7 So my remainder is .7 , I want to be left with only 7 I need to be able to take any remainder and subtract it from 10 So if my answer has a remainder of .7 I need to be able to do...
  11. D

    Counting Remainder from division and subtraction

    Hello, I have a number in variable X. Variable X is a time for instance 10, 14.5, 17.9 hours. I have n boxes which each contain 4 hours. I need to figure out how many full 4 hour boxes X fits into, and fit the remainder into the last box. Here is an example: X=17.9 hours Box 1 = 4 Box 2 = 4...
  12. N

    Remainder of division in VBA

    Im working on a macro in CorelDraw part of which needs to simplify a rotational angle so that it is between 0 and 360 degrees eg. 361.5 is converted to 1.5 and 720.15 would become 0.15 In VBA it seems that the MOD function returns a rounded integer but I would like to keep the fractional part...
  13. L

    Mod function in VBA

    How can I use the MOD function in VBA? I would like to divide a number by nine and keep only the remainder.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...