title: Excel error on function MOD
body: <p>I want to input this formula in my excel file (VBA preferably). But from some reason I get an error when I put this function im my formula bar:</p>
  
  <pre><code>#NUM! - Number Error
  </code></pre>
  
  <p>My function is:</p>
  
  <pre><code>=98-mod(2000000000123456*100;97))
  </code></pre>
  
  <p>But When I enter just 10 digits, then it works. I need to work with 16 digits.
  I am trying basically to validate number based on  ISO 7064 Mod 97,10 formula
  Thanks in advance.</p>
  
  <p>Thanks pepople, for your effort, but I've tried code that @Robyn wrote, and I get overflow error. Here is my code (I will write just Function section):
  'Note: An entering paramters are: 3259300700853850 and 97</p>
  
  <pre><code> Function DblMod(Dividend, Divisor)
  ' Declare two double precision variables
  Dim D1 As Double
  Dim D2 As Double
  ' Copy function arguments to local variables
  D1 = Dividend
  D2 = Divisor
  DblMod = D1 Mod D2
  End Function
  </code></pre>