MOD Articles: Excel and Google Sheets

All resources related to MOD for Excel and Google Sheets.


Get Number at Place Value
We can use a formula that is based on MOD to get a number at place value. Place value in this context refers to ones, tens, hundredths and so on. This post provides a step-by-step guide on how to get a number at a specified place value. Figure 1: Get...
How to Use the MOD Function in Excel
In Excel, sometimes you need to deal with some complex tasks like to sum or highlight cells that have even or odd numbers, sum every Nth row or column in a range, validate cells to enter numbers with even or odd or without a fraction, and many more. To solve...