Excel error on function MOD
<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>