Miscellaneous Functions
Macro Name
Returns
Description
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
Copyright IBM Corporation 2013. All Rights Reserved.