From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Finding the remainder with MOD and using MOD with conditional formatting

Finding the remainder with MOD and using MOD with conditional formatting

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Finding the remainder with MOD and using MOD with conditional formatting

“

- Excel has a function called MOD, and it does something that probably most of us would not ever need. The MOD function allows us to come up with the remainder in a division problem. If you go to the formulas tab, and you happen to encounter this, it's under Math and Trig. MOD returns the remainder after a number is divided by a divisor. Why would you ever want to use that? Well, there's one situation where you might want to use it. Imagine you work for a company. They've got a distribution center. They've got a bunch of items on stock there. They're going to move their distribution center, so they have to pack up everything and move it elsewhere. And for all the different items that we see identified in column A by the item number we have so many items in stock. Now, for each of the different items, there are boxes available, but depending upon the item, we can only get so many items per container. In other words, there are different kinds of containers for each. So, for the first…

Contents