How to Use the ISODD and ROW functions to determine odd rows
In this example, we need to determine whether a row number in a range is even or odd, and then fill each odd row with the character “X”. Use the ISODD function in combination with IF and ROW() to get the result shown in the image below. If this function is not available and returns an error, install and load the Analysis ToolPak add-in.
To determine odd rows and mark them:
- Select cells A1:E11 and type the following formula: =IF(ISODD(ROW()),”X”,”").
- Press Ctrl+Enter.
To mark all even rows, use the following formula: =IF(ISEVEN(ROW()),”X”,”").
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- Use the ISODD and COLUMN functions to determine odd columns
- Use the ISEVEN and ISODD functions to check if a number is even or odd
- Use the EVEN and ODD functions to determine the nearest even/odd value
- How to Use the ROW function to mark every other row in Excel
- How to Use the SUBTOTAL function to count rows in filtered lists
