G
Guest
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?
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?