Mod() Function

[mphekin12]

Can someone explain how mod(-4,3) returns a value of 2?

Thank

[robert_mika]

When working with negative number we are looking for value larger  absolute value.

In this case -6 is larger than -4

and

-4=-6+2

[mphekin12]

Robert,

Thanks for your reply but I am still not clear.  Where are you getting the -6 from?

[robert_mika]

Is the first number greater than 4 divided by 3.

[Qrishna · Accepted solution]

I think it's working like the Excel function, and this function can be (according to Excel Help) evaluated like:

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

So:

mod(-4,3) = -4 - 3*(-2) = +2

How this function works?

[mphekin12]

Krishna,

Thanks for the explanation, now it makes sense!