Microsoft Excel Functions & Formulas

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 Figure 6-34.

If this function is not available and returns an error, install and

load the Analysis ToolPak add-in.

4

To determine odd rows and mark them:

1. Select cells A1:E11 and type the following formula:

=IF(ISODD(ROW()),"X","").

2. Press <Ctrl+Enter>.

Note: To mark all even rows, use the following formula:

=IF(ISEVEN(ROW()),"X","").

Mathematical Functions

179

6

Figure 6-34