Excel Guides

Determining If a Number is Odd or Even in Excel

To determine if a number is odd or even in Excel, you can use the MOD function. This function returns the remainder after a number is divided by a divisor. For example, the formula =MOD(5,2) returns the value 1 because 5 divided by 2 equals 2 with a remainder of 1.

If you want to test if a number in cell A1 is odd or even, you can use this formula:


If the result is 0, the number is even. If the result is 1, the number is odd.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.