View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Steve Garman Steve Garman is offline
external usenet poster
 
Posts: 107
Default Variables not showing value


Todd Huttenstine wrote:
See here is VBA examples:

MyResult = 10 Mod 5 ' Returns 0.
MyResult = 10 Mod 3 ' Returns 1.
MyResult = 12 Mod 4.3 ' Returns 0.
MyResult = 12.6 Mod 5 ' Returns 3.

I do not understand how they are getting these numbers. I can understand 10
mod 5 and even 10 Mod 3 but the other 2 do not make sense.


Mod rounds to integers before it starts

12 Mod 4.3 is the same as 12 Mod 4
12.6 Mod 5 is the same as 13 Mod 5