Manuals/calci/MOPWITHMOD

MOD(Number,Divisor)


  • and 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:   with remainder  . Here   is the dividend,   is the divisor,   is the Quotient and   is the remainder.So  .
  • For e.g., MOD(5,2)=1. Here 1 is the remainder.
  • Ler number be "n" and the divisor be "d"
  • The   function we can write using   function:  .
  • 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 also with same sign.
  • But   and   are with different then the result will come with the   sign only.

ZOS

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

Examples

  1. =MOD(7,2)=1
  2. =MOD(-19,-3)=-1
  3. =MOD(75,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


References

Mod