remainder

I'd like a formula that examines a cell and an array to determine what, if any funds are available to fund a reference cell. Example: Budget$500 Request:Available: Item (Priority #1)$350$350 Item (Priority #2)$100$100 Item (Priority #3)$250$50 Item (Priority #4)$75$0 What...

Hi All, I'm having difficulties figuring out what function to use in the OUT column (B) to calculate the following: If the number in OUT (G) is greater than the TOTAL C then it should only show the MAX of TOTAL (C) otherwise subtract the remainder from the next instance of the colour (A) Blue...

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

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

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?

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!

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

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

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

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

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

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!

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

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

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

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