Difference between revisions of "Manuals/calci/REMAINDER"

Latest revision as of 10:33, 9 June 2020

REMAINDER(Number,Divisor)

OR

MOD (Number,Divisor)

This function gives the remainder of the number after dividing with given number. This is similar to function $MOD()$
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 $REMAINDER(X,Y)=R$ .
This function will return the result as error when the $Y$ value is 0.
Suppose the value of $X$ and $Y$ with same sign either '+' or '-',then the result is also displayed with the same sign.
But if $X$ and $Y$ are with different signs,one positive and other negative, then the result will have $Y$ 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.,REMAINDER(10,2),REMAINDER(50.2,-4)

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

For an array of numbers/dividends, a table with remainder values is displayed as follows -

@@ Line 26: / Line 26: @@
 #=REMAINDER(-52,7)=4
 #=REMAINDER(0,9)=0
-#=REMAINDER(9,0)=NAN
+#=REMAINDER(9,0)=#N/A (DIVISOR == 0)
 #=REMAINDER(5.5,2)=1.5