如果有多个单元格进行分别合并,我们似乎不能知晓是哪个单元格合并了,但实际上我们稍作技巧改动就能判断,举例如下:
 
 
1、我们需要对1行1列与2行1列单元格进行合并判断
2、我们需要对3行1列与4行1列单元格进行合并判断
 
方式如下:
1、判断1行1列单元格是没有合并的,代码如下:
 TABLE("BG-1|1|1","单元格合并判断","0") = "0"
2、判断2行1列单元格是合并的,代码如下:
 TABLE("BG-1|2|1","单元格合并判断","0") = "1"
3、判断3行1列单元格是没有合并的,代码如下:
 TABLE("BG-1|3|1","单元格合并判断","0") = "0"
4、判断4行1列单元格是合并的,代码如下:
 TABLE("BG-1|4|1","单元格合并判断","0") = "1"
 
最终代码如下:
TABLE("BG-1|1|1","单元格合并判断","0") = "0"
TABLE("BG-1|2|1","单元格合并判断","0") = "1"
TABLE("BG-1|3|1","单元格合并判断","0") = "0"
TABLE("BG-1|4|1","单元格合并判断","0") = "1"
 
 
合并单元格判断位置如图: