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.
