Manuals/calci/REMAINDER

REMAINDER(Number,Divisor)

OR

MOD (Number,Divisor)

• $Number$ is a single number or set of numbers, and
• $Divisor$ is any real number.
  • REMAINDER(),returns the remainder from division.

Description

• 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.

ZOS

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

Examples

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

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

• REMAINDER(11..15,4)

Number	Divisor	MOD
11	4	3
12	4	0
13	4	1
14	4	2
15	4	3

• REMAINDER([66,34,21],8)

Number	Divisor	MOD
66	8	2
34	8	2
21	8	5

Related Videos

Remainder

See Also

• MOD
• INT
• ROUND

References

Remainder

• List of Main Z Functions

• Z3 home