mod

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

    Prime number test Mod overflow error

    I'm trying the google, "find the first 10 digit prime in the digits of PI problem" and I'm stuck. I have the logic for it but i keep running into mod errors. Some of this code is lifted as I crashed while doing my last itteration and am too fried to rewrite. Any help is appreciated. Sub...
  3. R

    Mod in VB code

    Hi... I have a value in RowCount that once I divide it by 3, if there is a remainder then add 1 to RowCount. The following test formula works however, I am trying to accomplish the same in VB. In my VB, the N1 in the formula below would be my RowCount. =IF(MOD(N1,3)<>0,INT(N1/3+1),INT(N1/3))...
  4. J

    Date Formula

    trying to write a formula that makes a cell display the 1st Wednesday of the current month. :confused:
  5. 1

    Synatx Help

    I have a range of numbers and want to return a rounded value of 10% in increments of 50. For example, the following Numbers give the associated Answers: Number - Answer: 1,000 - 100 1,526 - 150 2,010 - 200 2,600 - 250 3,125 - 300 4,552 - 450 What syntax do I need to use to give me the...
  6. 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.

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