|
The NOT operator can be abbreviated with an exclamation mark (!). Use the exclamation mark before the data value (for example, to specify NOT(V1), you can simply type !V1).
|
TEMP = NOT(3.2) or TEMP = !1
Creates a new column named TEMP containing the value zero.
|
TEMP = !0 or TEMP = !(2+2=3)
Creates a new column named TEMP containing the value one.
|
Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the logical NOTs of values in column V1, the values of the VX column are the logical NOTs of the values in column V2, and the values of the VY column are the logical NOTs of the values in column V3.
|
Creates a new column named TEMP, where the first 11 cells contain the logical NOTs of the values in rows 10-20 of column V1. The other cells in TEMP are empty.
|
Creates two new columns named TEMP and VX, each with values in rows 1-5 (the other cells are empty). The values in column TEMP are the logical NOTs of the values of the corresponding rows of column V1, and the values in column VX are the logical NOTs of the values of the corresponding rows of column V2.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|