Manuals/calci/MOD

MOD(Number,Divisor)

• $Number$ and $Divisor$ are any real numbers.
  • MOD() returns the remainder from division.

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.

ZOS

• The syntax is to calculate remainder of the given numbers in ZOS is $MOD(Number,Divisor)$.
  • $Number$ and $Divisor$ are any real numbers.
• For e.g.,mod(10,2),mod(50.2,-4)

Examples

1. =MOD(5,2)=1
2. =MOD(-11,-3)=-2
3. =MOD(25,5)=0
4. =MOD(12,-4)=0
5. =MOD(85,-9)=-5
6. =MOD(-52,7)=4
7. =MOD(0,9)=0
8. =MOD(9,0)=#N/A (DIVISOR == 0)
9. =MOD(5.5,2)=1.5

Related Videos

MOD

See Also

• INT
• ROUND

References

Mod

• List of Main Z Functions

• Z3 home