Thread: MOD
View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default MOD

J.H. wrote...
I have a question on the funtion "MOD". When the number to be divided is more
than nine digits (like: 1,234,457,890), the funtion would return error. How
can I fix this?


As others have pointed out, Excel's MOD function is flawed compared to
what the hardware is capable of calculating. Instead of MOD(a,b) calls,
use (a-b*int(a/b)).