It is worth knowing in detail the MOD function of Excel. In combination with other formulas, it provides practical solutions for many day-to-day problems.
Excel's RESIDUE function is used in formulas in which only certain minimum amounts are counted, that is, only each x value. The most common examples are calculations of handling units or production batches , the conversion or calculation of quantity and length units, as well as date residuals .
Additionally, Excel's RESIDUE function can be combined with other formulas , for example, with the SUMIF function, the SUMPRODUCT formula, or the SUBTOTALS function.
Let's imagine you have a predetermined number of units to be used in the production of a batch. This is a situation in which residual stocks can be generated , either because machines need to produce a certain quantity to be profitable or because regulations only allow certain quantities to be packed. Excel's RESIDUE function allows you to calculate these residual stocks. Thus, you can distinguish between usable and unusable remains. In addition, the SUMIF function allows you to determine if there is waste and if it can be reused.
This method also works for grouping volumes : the combination of the SUMPRODUCT formula and the WASTE function in Excel makes it possible to guarantee, for example, the optimal loading of a ship container.
Finally, Excel's RESIDUE function can also be useful when making transfers . With low amounts, transfers are often too expensive. If a customer places very few orders in a month, but makes many the following month, you can use Excel's RESIDUE function with the SUMIF function and SUBTOTAL function to effectively group amounts or volumes of product categories and reduce the effort in the office.