From ZCubes Wiki
Jump to navigation Jump to search

  • and are any real numbers.
    • MOD() returns the remainder from division.


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


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


  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


See Also