Manuals/calci/MOD

MOD(n,d)

• $n$ is any real number and $d$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

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

MOD(-52,7)=4 MOD(0,9)=0 MOD(9,0)=NAN MOD(5.5,2)=1.5 Syntax

---

Remarks

---

Examples

---

'''''''  ''''

---

Description

---

MOD

---

 

MOD (N, D)

N   is the number.

D is the divisor.

---

      If Divisor is 0, MOD shows the error value.

---

 This function calculates the remainder of a number after division.

---

 

Lets see an example in (Column1 Row 1, Column2Row1)

MOD (N, D)

MOD (C1R1, C2R1)

i.e. = MOD (5, 4) is 1

---

	Column1	Column2	Column3	Column4
Row1	5	4
Row2	1
Row3
Row4
Row5
Row6

File:Calci1.gif

---