MOD(Number,Divisor)
- and are any real numbers.
- MOD() returns the remainder from division.
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
- 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
- =MOD(7,2)=1
- =MOD(-19,-3)=-1
- =MOD(75,5)=0
- =MOD(12,-4)=0
- =MOD(85,-9)=-5
- =MOD(-52,7)=4
- =MOD(0,9)=0
- =MOD(9,0)=#N/A (DIVISOR == 0)
- =MOD(5.5,2)=1.5
Related Videos
See Also
References