Table of Contents
The MOD function in Excel allows users to find the remainder of a division between two numbers. By entering the function followed by the two numbers separated by a comma, Excel will return the remainder value. This can be useful for various calculations, such as determining if a number is odd or even, or for organizing data into groups or categories. The MOD function is a helpful tool for performing quick and accurate calculations in Excel.
This article describes the formula syntax and usage of the MOD function in Microsoft Excel.
Description
Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
Syntax
MOD(number, divisor)
The MOD function syntax has the following arguments:
Number Required. The number for which you want to find the remainder.
Divisor Required. The number by which you want to divide number.
Remarks
If divisor is 0, MOD returns the #DIV/0! error value.
The MOD function can be expressed in terms of the INT function:
MOD(n, d) = n – d*INT(n/d)
Cite this article
stats writer (2024). How can I use the MOD function in Excel to find the remainder of a division between two numbers?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-mod-function-in-excel-to-find-the-remainder-of-a-division-between-two-numbers/
stats writer. "How can I use the MOD function in Excel to find the remainder of a division between two numbers?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-mod-function-in-excel-to-find-the-remainder-of-a-division-between-two-numbers/.
stats writer. "How can I use the MOD function in Excel to find the remainder of a division between two numbers?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-mod-function-in-excel-to-find-the-remainder-of-a-division-between-two-numbers/.
stats writer (2024) 'How can I use the MOD function in Excel to find the remainder of a division between two numbers?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-mod-function-in-excel-to-find-the-remainder-of-a-division-between-two-numbers/.
[1] stats writer, "How can I use the MOD function in Excel to find the remainder of a division between two numbers?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the MOD function in Excel to find the remainder of a division between two numbers?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.