MOD function is used to get the remainder of number that is divided by divisor.
MOD Function has two required arguments i.e. number and divisor.
=MOD(number,divisor)
number argument is the used to give the number/cell reference of which you want remainder
divisor argument is used to give number/cell reference from which number should be divided
Here, we have sample database and want to get the remainder:
To understand the uses of the MOD function, let’s learn with the help of example:-
– If divisor is 0, Output returns “#DIV/0!” error
– Output value sign would be same as divisor
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell
How to count words in Excel using the LEN function along with other Excel functions. It also gives formulas for counting words or text, whether case-sensitive or not, in a cell or range.
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
The tutorial explains how to use the CHOOSE function in Excel, showing you the basics and some interesting examples. While CHOOSE might seem simple on its own, when you combine it with other functions, it can be powerful. Essentially, the CHOOSE function helps you pick a value from a list based on its position. The tutorial also covers some advanced ways to use CHOOSE that you might find very useful.