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
- 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