Mod Function
OK, need help with the following:
Mod(10e+11;97) returns #NUM!, anything higher it blows.
But if I use Mod(n;d)=n-d*INT(n/d) I can go until Mod(10e+15;97), anything
higher it returns increasingly lower negative values instead of the real
value.
My doubt is: If I can calculate this values in the windows calculator why
can't Excel do the same? In the windows calculator I was able to calculate
Mod(10e+32;97), and I suspect i could go higher. Could someone help?
Thanks in advanced.
|