Manuals/calci/MOD

From ZCubes Wiki
Revision as of 23:59, 2 July 2014 by Devika (talk | contribs)
Jump to navigation Jump to search
MOD(number,divisor)


  • and are any real numbers.

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 Section

  • 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(5,2)=1
  2. =MOD(-11,-3)-2
  3. =MOD(25,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)=NAN
  9. =MOD(5.5,2)=1.5

See Also

References

Mod