In this post, let’s learn Modulus function in Microsoft Excel and how you can use this in your excel spreadsheet.
Modulus function returns the remainder when you divide two numbers.
Syntax – MOD(number, divisor)
Here the number is the number to be divided by the divisor.
Let’s take a look at few examples.
Note that the remainder should always be of the same sign as the divisor.