判斷三格是否空白 (13480)

C3=OFFSET(E2,CHOOSE(N(B1=0)+N(A3=0)*3+N(B3=0)*5+1,1,,,,5,2,4,,3,6),)

無表列=LOOKUP(1,0/((N(B1=0)&N(A3=0)&N(B3=0))-{0,1,11,101,110,111}=0),{18,180,1800,18000,2000,36000})



留言