mod

Hi Someone worked from 10:00pm to 6:00am next day. I want to calculate the difference. So I tried A1=10 pm B1= 6 am C1=(A1-B1)*24 But did not work I watched a video and the guy said use =Mod((B1-A1),1) But did not explain why. I know what mod is used for but how this idea came from? Mod...

Hello guys, I have issues in writing a formula that define the multiples. I need a formula like this: If the number is multiple of another number do put a cell otherwise null (""). I used the Mod formula in this way: =SE(MODA(E84;J1)=0;D83;"") The formula is not working, E84 is 3 and J1...

I am trying to set up a formula using maybe the MOD feature in excel to show break downs for pay-out spots (Golf Tournament) for this example 1st thru 7th position. Total amount of money is $4,680 Finishing 1st 2nd...

I have a data like below. Lets say for the first occurrence in the First row, I use a formula to specify that a value, say 55, must be inputted in Feb and the data inputted every 3 months subsequently i.e the next one in May. I tried using mod and count but not working as I want it to. Will be...

I need some help. I am trying to take data in a column and reference it in another spreadsheet with a formula/function. The difference is the new data will need to be in the new spreadsheet with an empty row in between. With the amount of data I have, I need to be able to copy down the...

I am slightly familiar with the OFFSET formula. I would like to extract the data from Column B into Column F in that order, skip rows and do the same for the data for Tina Fey, etc.. Possibly one continuous formula? Is this possible? <tbody> A B C D E F 1 CLIENT INFO 2 Name Bob Ross...

Hi, Thanks for your assistance and time. This formula works nice for my needs, of repeating a value. =if(mod(column()-1,3)=0,$a$4,0) it displays my value every 3rd column, in row 4. I have 365 columns with date in row 3, for each day of the year. E3 has Jan 1, 2018. i want to put a date in...

Hi, I tried to post a new thread about 3 hours ago and nothing has come through. Just wondering if this is normal procedure and if a mod could please look into it Thanks

I'm making a table with all the dates in a month. The user picks month and year. I have just the code listed below that calculates leap year for February and all other months of any year. The problem is that it does not calculate February during a non-leap year. The Application-defined or...

i tried this With Worksheets("Hilfstabelle") Worksheets("Linienauswertung").Range("G14").Value = Application.WorksheetFunction.SumProduct((.Range("D2:D" & Zeilenzahl)) * (.Range("A2:A" & Zeilenzahl) Mod 10), "<9") End With what i want is, sum the values in Column D for each row, where...

I am not sure if this is an easy task and I am just missing something but here is what I need. I need a formula that will assign a weight (with all weights adding up to 1 of course) to data in excel based off whether that data has a rating of "Low," "Mod" or "High." Naturally, low would have the...

Hello guys, I’m new in VBA and can’t figure out how should I move forward. I’m using the below mentioned macro to calculate different requirements. It works fine if the frequency values in column B are divisible with lowest frequency, for example 100, 200, 400 & 500. However if there is an...

Hi I've recently upgraded to Excel 2016. A webscraping programe written with 2007 stops working (not responding) with Excel 2016 It'll start to loop through a list of websites but just stops responding after 3 or 4. I've tried exporting the mod,saving as a non-macro workbook and importing the...

Hi, I'm an Excel newbie and in a bit of a pickle. I'm trying to find the sum of a range of cells (A1:C12) for numbers between 20 to 80, but only ones that are even numbers. I'd normally do this with a SUMIFS function easily, but I have no idea how to narrow it down to just the even numbers...

I get the same answer using MOD as I do using AND with regards to the code below. Note the difference of using 256 vs 255. Could someone explain what the AND is doing, I don't get it and I can't find the answer online. Never seen it used like this before. Just curious. Thanks for your time: r =...

I was trying to use the MOD function to get the portion of a number to the right of the decimal point. =MOD(M32,INT(M32)) However when M32 is zero I get an error message #DIV/0 In most cases the number in M32 will be in the format XX.XXXXX. What function can I use to avoid this error message?

Hi , This code works fine. (Split Column A & B to 3 columns) Sub SplitInto3CellsPerColumn() Dim X As Long, LastRow As Long, vArrIn As Variant, vArrIn2 As Variant, vArrOut As Variant, vArrOut2 As Variant LastRow = Cells(Rows.Count, "A").End(xlUp).Row vArrIn = Range("A1:A" & LastRow)...

I need to count not only by item no but also color. In the following example, the desired result is in blue. Row 5 and 6 have the same item number and color. Thus, the sum is 22 (16+6). The closest thing I can get is with the following formula, whose result is in the last column. It seems I need...

Hey folks. I'm looking to create a dynamic checklist based on the role ("user X" in the table below). The end result is to print off a sheet of paper for each user and verify each required step was complete, not all steps are required. I can get the data using INDEX (thanks Jonmo1 !). In the...

Afternoon My question today is I am trying to apply multiple conditions to a cell. The first condition formats the cell blue if the mod is 0. I would also like to format the font bold. (Maybe other formatting as well) The code I am using below. Thank You. Sub format_every_other_row()...