Which function is used to return the remainder after a number is divided by a…
2025
Which function is used to return the remainder after a number is divided by a divisor in Excel?
- A.
ROUND ( )
- B.
FACT ( )
- C.
MOD ( )
- D.
DIV ( )
Attempted by 1 students.
Show answer & explanation
Correct answer: C
Concept
Excel's MOD function performs the mathematical modulo operation: MOD(number, divisor) returns the remainder left over after number is divided by divisor as many whole times as possible. The result takes the sign of the divisor, and dividing by 0 returns a #DIV/0! error.
Application
The question asks for the function that returns this remainder, so the built-in function designed exactly for that purpose is MOD ( ).
Why the other options don't fit
ROUND ( ) rounds a number to a specified number of digits - it changes precision/display, it does not compute what remains after a division.
FACT ( ) returns the factorial of a number (the product of all positive integers up to it) - a multiplication operation, unrelated to division remainders.
DIV ( ) is not a built-in Excel worksheet function at all - Excel has no function under this name.
Cross-check
As a check: MOD(10, 3) evaluates to 1, because 10 = 3x3 + 1. Equivalently, MOD(number, divisor) = number - divisor*INT(number/divisor), confirming that MOD computes exactly the division remainder.
So the function used in Excel to return the remainder after division is MOD ( ).