Manuals/calci/MOPWITHMOD

MOD(Number,Divisor)

Description

This function gives the remainder of the number after dividing with some number.
When we divide two integers we will get the result like this: ${\frac {X}{Y}}=Q$ with remainder $R$ . Here $X$ is the dividend, $Y$ is the divisor, $Q$ is the Quotient and $R$ is the remainder.So $MOD(n,d)=R$ .
For e.g., MOD(5,2)=1. Here 1 is the remainder.
Ler number be "n" and the divisor be "d"
The $MOD$ function we can write using $INT$ function: $MOD(n,d)=n-d*INT(n/d)$ .
This function will return the result as error when the $d$ value is 0.
Suppose the value of $n$ and $d$ with same sign either '+' or '-',then the result also with same sign.
But $n$ and $d$ are with different then the result will come with the $d$ sign only.