1. E

    Need Help!: Subtract number from cell until it reaches 0, then subtract remainder from different cell

    Need Help!! I can't for the life of me figure out how to do this. I am looking for a formula that will allow me to do this: Cell O46 tracks the current Hit point points of a character. The max HP is found in cell G46, which is used to calculate the current HP by suming all the damage done in a...
  2. 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...
  3. 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?
  4. 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!
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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!
  11. 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...
  12. 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...
  13. 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...
  14. 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.

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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