mod

Hi Everyone, I'm getting the VBA run-time error 6, "Overflow." I've defined what I think are the applicable variables as long, and I think that should be enough for my purposes. I have Dim dArray(0 to 9), mySum As Long and the problem is at the line where two 10-digit numbers are being added...

Hello! I am having some trouble trying to add cell values together starting from N14 through to N1805. I would like the formula to include these cells and every 9th cell in between. For Example, the first cell in the sum would be N14, then N23... Through to N1805. I believe it is a MOD...

If anyone can help me understand what Excel is doing here, I would be very grateful. I want to create a frequency chart basically using the % of something. I have a range of values between 0.00 and 1.00. In an adjacent column I have the formula A1 - Mod(A1, 0.1) for most of the results it...

Greets- Ran into bogosity where MOD (N,12) gives a result of 12 when N is evenly divided by 12 so should give a result of 0! Any1 run into this B4? Samsung Tab Pro 12.3 inch tablet w/Android running office suite app Polaris.

Howdy, I'm attempting to use conditional formatting to highlight every other group of similar rows. I've been using the following formula in conditional formatting and it's been working fine, but I'm trying to adapt it to look at two other columns as well...

Hi, If I have a start date of 7/4/2016, end date 12/31/18 and I need $15,000 to appear on July 2016, then October 2016, then January 2017, every 3 months until the end date --> what formula does this? Column A <tbody> Invoice Start Date Invoice End Invoice Amount 7/31/2016 8/31/2016 9/30/2016...

So I have a date formatted as MM/DD/YY and I need to determine the day of the week using the MOD function and a single IF Statement and I have no idea how to do this? Any help would be appreciated. Also the date I chose was 3/16/2016

Hi again guys! Thanks to you I'm optimizing a lot my worksheet! I have another question to ask you. AQ2: =(AO2-AP2). That ecuation gives me a result that I need to round with the next criteria: If the result ends with the digits: 2, 3, 4, round it to end with 5 (ie. 102, 103, 104, round to...

Hello everyone, How can I achieve this? I need to do this for over 10,000 cells. If I drag and drop, it picks up every alternate A and B cells. Any suggestions are greatly appreciated. <tbody> A B C D 1 =IF(MOD(ROW(),2)=0,(IF(A1="","",A1)),(IF(B1="","",B1))) 2...

I have six columns and 15,625 rows. My data is working with combinations of +2 to -2. In column A, I want to sequence my input data as +2,+1,0,-1,-2 and then repeat until row 15,625 In column B, I want to sequence it as five +2s, then five +1s, then five 0s, then five -1s, then five -2s. In...

Hi, I need help with writing the Mod and / functions in VBA in a different way. I read in another thread that these two intrinsically produce results of the Long data type. But I need more than that. This is my convertToHex function which takes in as argument a decimal number: result = ""...

Thisis the code that I was using. Note:ISBLANK. IF(ISBLANK(R121"",IF(U121=0,"",MOD(R121-I121,1))) I changed it toIF(R121<>"",IF(U121=0,"",MOD(R121-I121,1))) And now I get"FALSE" in cells that are not used yet. Please note, ifthere is no 'Reading', then the row is blank. But if there is...

Hi, I am trying to get an average of the values of every second cell in a range along a single row. Some of the cells in the range will be blank and I don't want those cells included in the average total or divisor. However some of the cells will have 0 in them. I do want these cells included...

I am trying to use the following formula to find the MAX value in a row of data. =SUMPRODUCT(MAX((C1:Z1)*MOD(COLUMN(C1:Z1),2))) Esentially, I want to ignore the values in odd Columns like D and F and choose the max value in even columns like C and E. When I select parts of the formula and hit...

Hi all Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 P&L VAT charge 3 -21 -50 -25 -60 -2 -78 -10 -36 -44 -99 -6 Quarterly Pmt -68 -87...

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

Hello Mr. Excel, I have been searching on multiple occasions for a solution to my highlighting needs. At one point and time I found a guide that showed me how to highlight all rows that had the same cell value, then when the cell value changed it would alternate the shading. It used a MOD...

I have a list of eight names. Is there a formula where I can make the first name repeat from a1:a6, second a7:a12, so on and so forth.

The following formula works fine as long as the integer in cell A1 has 12 digits or less. I get a #NUM! error otherwise (13 or more digits). Any help is appreciated. =MOD((A1-MOD(A1,POWER(10,ROW(A2)-2)))/POWER(10,ROW(A2)-2),10)

Hello. Straight to my situation. A1: positive integer A2: positive integer A3: MOD(A1/A2,1) A4: 1*(A3=0) A5: A3+A4 The above MOD function in A3 returns values between: 0 < = (A1/A2) < 1 In A5 I manage to have: 0 < (A1/A2) < = 1 Which is what I want. That result in A5 is almost the same...