mod

  1. A

    SUM Formula to Add Every Nth Row

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

    Strange behaviour with MOD function

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

    MOD function "feature"

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

    Conditional Formatting based on Multiple Values

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

    Return a value every 3 months from a start date

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

    Dayweek Help

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

    Round numbers based on last digit

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

    Formula in Alternate rows that do not reference alternate

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

    Number intervals - positive to negative

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

    Help with Mod and / Functions in VBA

    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 = ""...
  11. W

    Why is "VALUE" appearing?

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

    Average Issues

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

    Use SUMPRODUCT and MOD to Find MAX in Odd Numbered Columns

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

    VAT Payments Conditional Sum with MOD function--HELP can't figure this out

    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...
  15. 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...
  16. M

    Dynamic Color Banding on similar rows with Filtering

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

    Listing Question

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

    #NUM! error when number is 13 digits or more

    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)
  19. A

    little change to MOD function

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

    little change to MOD function

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

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top