MOD is more versatile thank you might think.
Type into cell A2 8 as the Number and cell B2 2 as the Divisor and then press Enter. The result would be 0. Type more numbers and divisors into your spreadsheet, then on the result column, drag the ...
Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For ...