楼主 儒道佛 |
------ 目录 ------ [1]引用运算符的定义 [2]优先级判定四法 [3]使用范围限制 对于二元运算符, 中文比较常见的译法是: 联合(合并、并集)、 区域(区间)、 交叉(交集、集合) 至于官方的定义, 为准确起见, 给出原文。 3.2.5 Binary Reference Operators The binary reference operators tIsect (➜3.6.13), tList (➜3.6.14), and tRange (➜3.6.15) are always encapsulated into reference subexpression tokens . These tokens will change their token class, but the operands of the reference operators will not be changed. Because these operators require reference operands (constant references or functions returning a reference), the actual operands of these operators always have reference class. 3.6.13 tIsect Intersection operator, represented by the space sign. Returns the intersected range of two ranges. If the resulting cell range is empty, the formula will return the error code “#NULL!” (for instance A1:A2 B3). This token is not allowed in conditions of conditional formattings and in data validity. If this token is used in cell formulas, it prevents the creation of shared formulas. Operand class: reference. Example: A1:B3 B2:C3 returns B2:B3. 3.6.14 tList Range list operator, represented by the system's list separator sign (for example comma sign). Treats two ranges as one operator. This might be useful for function parameters. Note: This is not a union operator. This token is not allowed in conditions of conditional formattings and in data validity. If this token is used in cell formulas, it prevents the creation of shared formulas. Operand class: reference. Example: (A1:A2,A2:A3) will be handled as one operand. Cell A2 will be handled twice, therefore this is a range list operator, no union operator. 3.6.15 tRange Range operator, represented by the colon sign. Returns the minimal rectangular range that contains both parameters. This token occurs for instance by using defined names. This token is not allowed in conditions of conditional formattings and in data validity. If this token is used in cell formulas, it prevents the creation of shared formulas. Operand class: reference. Example: namedcell:D5 returns A1:D5, if the defined name namedcell contains A1:B2. 红色标注部分,官方的描述与实际不符, 请看二元引用运算符之:使用范围限制 http://www.exceltip.net/thread-1878-1-1.html 官方文档.png |
2楼 亡者天下 |
感觉好复杂啊 |