November 29th, 2007, 02:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|
|
Mod Function
It's a well known bug
http://support.microsoft.com/default...b;en-us;119083
--
Regards,
Peo Sjoblom
"Diogo" wrote in message
...
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.
|