="0"&IF(ISERROR(FIND("0",A1)>0),"/","*")
填入是0的格,别的数值格自已改动一下,比如2的格就是 ="2"&IF(ISERROR(FIND("2",A1)>0),"/","*") 是别的行则手动改单元格的名称,比如第二行就是
="0"&IF(ISERROR(FIND("0",A2)>0),"/","*") 看了补充公式改一下 B3
=RIGHT(LEFT($A1,1)+RIGHT($A2,1)+COLUMN(B$1)-1)&IF(ISERROR(FIND(RIGHT(LEFT($A1,1)+RIGHT($A2,1)+COLUMN(B$1)-1),A3)>0),"/","*")...
|