Manuals/calci/REMAINDER

REMAINDER(Number,Divisor)


OR

MOD (Number,Divisor)


  • is a single number or set of numbers, and
  • 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  
  • When we divide two integers we will get the result like this:   with remainder  . Here   is the dividend,   is the divisor,   is the Quotient and   is the remainder.So  .
  • This function will return the result as error when the   value is 0.
  • Suppose the value of   and   with same sign either '+' or '-',then the result is also displayed with the same sign.
  • But if   and   are with different signs,one positive and other negative, then the result will have   sign only.

ZOS

  • The syntax is to calculate remainder of the given numbers in ZOS is  .
    •   and   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

References

Remainder