=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:
How to use Excel Function PROPER? PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which makes the function…
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.
This tutorial explains how the TRANSPOSE function works and shows you the right way to use it to switch data in Excel.
Everyone has different preferences, even for work habits. Some people like to arrange data in vertical columns, while others prefer horizontal rows. If you ever need to switch the direction of your data quickly, the TRANSPOSE function can help
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…
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k