writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + +
no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div style="font-size:30px">'''MOD(n,d) '''</div><br/>
*<math>n</math> is any real number and <math>d</math>is the divisor
==Descrition==
*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 R. Here X is the dividend, Y is the divisor, Q is the Quotient and R is the remainder.So MOD(n,d)=R.
*For e.g., MOD(5,2)=1. Here 1 is the remainder.
*The MOD function we can write using INT function: MOD(n,d)=n-d*INT(n/d).
*This function will return the result as error when the d value is 0.
*Suppose the value of n and d with same sign either '+' or '-',then the result also with same sign.
*But n and d are with different then the result will come with the d sign only.
==Examples==
#MOD(5,2)=1
#MOD(-11,-3)-2
#MOD(25,5)=0
#MOD(12,-4)=0
#MOD(85,-9)=-5
MOD(-52,7)=4
MOD(0,9)=0
MOD(9,0)=NAN
MOD(5.5,2)=1.5
Syntax
Syntax