How to Use the MOD Function in Excel
The MOD function is a maths and trigonometry function in Excel. It returns the remainder after a number is divided by a divisor.
At first glance, the MOD function does not really look to have much use. Many people are not that impressed at first and wonder how it could be incorporated into their day to day work. If you are an avid user of Excel though, you are sure to come across a situation requiring the use of the MOD function.Let’s have a look at how to use the MOD function in Excel.
The MOD Function in Excel
In the example below there is a requirement for a number of muffins. The muffins need to be boxed before they are distributed. There are three different sized boxes that can be used. The MOD function will help us find the best size box to use for each order to limit the number of left over muffins.
The syntax for the MOD function is;
Number: The number that you want to find the remainder for
Divisor: The number you want to divide the number byIn cell E2 the formula =MOD($D2, A2) was entered. This finds the remainder for the muffins using box A. The $ sign is used before D2 to hold column D so that the formula can be copied to the other 26 cells and still work ok.
Great Excel Learning Resources
Online training in building better workbooks using awesome formulas, visually stunning charts, analysing data and making effective dashboards.
Online video courses provided by authors who are experts in their field. Training courses include advanced formulas and functions, making dynamic charts, creating business budgets and Excel VBA.
More Excel Tutorials
- Handling Working Days in Excel
When working with dates in Excel at some point you will find it necessary to handle working days only. Excel provides a few useful functions to perform date calculations such as to find the number of working days between two dates.
- Calculating loan repayments in Excel
The payment or PMT function in Excel can be used to calculate loan repayments. This can be very useful in both personal and business life.
- Calculating future savings using Goal Seek
It is possible to calculate future savings for an account using Excel. The calculations will be based on the amount being put away or paid, a constant interest rate and savings period.
- Using Corporate Colours in Excel
When formatting text and cell colours in Excel, you may have noticed that you are limited to 56 colours. This can cause a problem when you need to use your companies corporate colours in a spreadsheet.