=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:
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.
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.