|
For example, with column ranges, the macro definition V6 = V1:V3 AND V4:V6 generates three output columns (both data ranges contain three columns). Column V1 is AND-ed with column V4; column V2 is AND-ed with V5 and column V3 is AND-ed with V6. However, V6 = V1:V3 AND V4:V5 returns only two output columns (the first column range contains three columns, the second contains only two, and the lesser of the two is used). In this case, column V1 is AND-ed with column V4 and column V2 is AND-ed with V5. Column V3 is not used.
|
|
With cell ranges, the macro definition V7 = V1[1:5]:V2 AND V4[10:50]:V5 generates two output columns (both input ranges have two columns). The output columns V7 and V8 will contain five values (cells 1-5 AND-ed with cells 10-14). The macro definition V7 = V1[1:5]:V2 AND V4 generates only one output column, because the second data range contains only one column.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|