=MOD(number,divisor)
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:
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”
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
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…
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1