Thread: Mod Function
View Single Post
  #1  
Old November 29th, 2007, 02:34 PM posted to microsoft.public.excel.worksheet.functions
Diogo
external usenet poster
 
Posts: 38
Default 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.