Buzz
MOD Function in Excel
Guide on how to use the MOD function in Excel - Illustrated Examples
Syntax: MOD (number, divisor)
Where:
- Number: required. The number being divided.
- Divisor: required. The number by which to divide.
Function: Returns the remainder after dividing one number by another. The result obtained has the same sign as the divisor (regardless of the sign of the number being divided).
For instance: Consider the following data table:
Calculate the remainder after dividing Number by Divisor. Apply the MOD function. The formula for cell C6 is: =MOD(A6,B6). The result is:
Copy the formula for the remaining cells. Note the obtained results:
- In cell C7. Even if the number being divided is negative, it does not affect the sign of the result because it follows the sign of the divisor.
- In cell C8. The divisor is negative so the result will be negative.
- In cell C9. The divisor is negative so the sign of the result will be negative.
Now that you have a solid understanding of the syntax and usage of the MOD function in Excel, you can apply it to perform calculations in your spreadsheets more efficiently. Additionally, you may want to explore: The POWER function for exponentiation, The DMAX function to find the maximum value in a row, column, etc.
