IF
|
One column with a value for each row of the shortest input column |
Begins a conditional if-then-else statement |
ISERROR
|
One column with a value for each row of the shortest input column |
Returns a one if any value in the input row contains an error (???) cell, else zero |
ISEVEN
|
One column for each input column |
Tests if input values are even (that is, divisible by two) |
ISODD
|
One column for each input column |
Tests if input values are odd (that is, not divisible by two) |
ROWNUM
|
One column for each input column |
Generates sequential numbers from one to the number of records |