नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor.
Syntax
MOD(<number>, <divisor>)
Parameters
| Term | Definition |
|---|---|
number |
The number for which you want to find the remainder after the division is performed. |
divisor |
The number by which you want to divide. |
Return value
A whole number.
Remarks
If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.
The MOD function can be expressed in terms of the INT function: MOD(n, d) = n - d*INT(n/d)
Example 1
The following formula returns 1, the remainder of 3 divided by 2.
= MOD(3,2)
Example 2
The following formula returns -1, the remainder of 3 divided by 2. Note that the sign is always the same as the sign of the divisor.
= MOD(-3,-2)
Related content
Math and Trig functions ROUND function ROUNDUP function ROUNDDOWN function MROUND function INT function