Manuals/calci/MOD

Revision as of 22:46, 25 December 2013 by Devika (talk | contribs)
MOD(n,d)


  • is any real number and is the divisor

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: X/Y= Q 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.
  • 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.


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