Use the ISEVEN and ISODD functions to check if a number is even or odd
To find out whether numbers are even or odd, use the ISEVEN or ISODD functions. ISEVEN returns TRUE if the number is even and FALSE if the number is odd, while ISODD returns TRUE if the number is odd and FALSE if the number is even.
ISEVEN(number)
ISODD(number)
number: The value to be tested. Non-integer values are truncated.
To check if a number is even or odd:
- In cells A2:A10 enter some numbers.
- Select cells B2:B10 and type the following formula: =IF(ISEVEN(A2),”X”,”").
- Press Ctrl+Enter.
- Select cell C2:C10 and type the following formula: =IF(ISODD(A2),”X”,”").
- Press Ctrl+Enter.
To use these functions, you will need to install and load the Analysis ToolPak add-in.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Use the ISODD and ROW functions to determine odd rows
- Use the ISODD and COLUMN functions to determine odd columns
- Use the EVEN and ODD functions to determine the nearest even/odd value
- Using the OR function to check cells for text or numbers in Excel
- How to Use the WEEKNUM function to determine the week number
