Difference between revisions of "Manuals/calci/MOD"

Latest revision as of 03:18, 9 June 2020

MOD(Number,Divisor)

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.

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

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''MOD(number,divisor) '''</div><br/>
+<div style="font-size:30px">'''MOD(Number,Divisor) '''</div><br/>
-*<math>number</math> and <math>divisor</math> are any real numbers.
+*<math>Number</math> and <math>Divisor</math> are any real numbers.
+**MOD() returns the remainder from division.
 ==Description==
@@ Line 13: / Line 14: @@
 ==ZOS==
-*The syntax is to calculate remainder of the given numbers in ZOS is <math>MOD(number,divisor)</math>.
+*The syntax is to calculate remainder of the given numbers in ZOS is <math>MOD(Number,Divisor)</math>.
-**<math>number</math> and <math>divisor</math> are any real numbers.
+**<math>Number</math> and <math>Divisor</math> are any real numbers.
 *For e.g.,mod(10,2),mod(50.2,-4)
@@ Line 25: / Line 26: @@
 #=MOD(-52,7)=4
 #=MOD(0,9)=0
-#=MOD(9,0)=NAN
+#=MOD(9,0)=#N/A (DIVISOR == 0)
 #=MOD(5.5,2)=1.5