how does mod work with negative numbers?

[daveyc18]

eg mod(4,-13) gives -9 ....how does that work?

 

[MoshiM]

eg mod(4,-13) gives -9 ....how does that work?

You have written 4 mod -13. When integer 4 is divided by integer -13, 4 is divided once with a remainder of -9.

 

[kweaver]

Excel's MOD function is defined as: MOD(n, d) = n - d*INT(n/d)

When d is negative, the sign of the answer is the same as the sign of the divisor.

In mod(4,-13): 4-(-13)*INT(4/-13) which is 4-(-13)*(-1) which is 4-13 which is -9.

 

[shg]

As it says in Help,

=MOD(n,d) returns =n-d*INT(n/d)