Excel MOD Formula to Determine Your Odds and Evens
top of page

Excel MOD Formula to Determine Your Odds and Evens

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.






bottom of page