=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:
Watch: How to use WORKDAY & WORKDAY.INTL Function in Excel? What is WORKDAY Function? The WORKDAY function in Excel calculates a date that is a specified number of working days before or after a given date. It…
AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”
Watch: How to use VLOOKUP Function in Excel? What is VLOOKUP Function? The VLOOKUP function in Excel searches for a value in a table and returns a corresponding value from another column in the same row…
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
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.
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.