The VBA "x Mod y" function and the Excel function =Mod(x,y) produce
consistent results when both parameters are positive. When the number, x, is
negative, these two functions produce different results.
For example the VBA function returns
- 1 = -1 Mod 3
and
the Excel function returns
2 = Mod(-1, 3)

I agree with the Excel function's results.

Anyone have any idea why these functions would have different results?