Thread: Mod Function
View Single Post
  #3  
Old November 29th, 2007, 02:58 PM posted to microsoft.public.excel.worksheet.functions
Diogo
external usenet poster
  
Posts: 38
Default Mod Function
Update:

Using:

Function MyMod(n, m)
MyMod = (CDec(n) - m * Int(CDec(n) / m))
End Function

I was able to go as far as mod(10e28;97), anything higher and it returns
#VALUE!

I need to go as far as 10e32, almost there

Any thoughts?