Excel MOD Formula to Determine Your Odds and Evens
- Sean O'Shea
- Dec 19, 2020
- 1 min read
Excel's simple MOD formula will let you know if numbers in a column are odd or even.
Simply enter the cell reference, followed by 2. If the number in the referenced cell is odd, a 1 will be returned. If it is even a 0 will be returned.






