有谁懂Excel不帮忙看一下这个公式是什么意思哦
有谁懂Excel不帮忙看一下这个公式是什么意思哦
IF(OR(W348=坐班!B$2:B$11,W348=坐班!B$17),INDEX(坐班!E$2:E$17,MATCH(W348,坐班!B$2:B$17,)),
IF(W348=坐班!B$12,
IF(OR(K348=坐班!B$2,K348=坐班!B$3,AND(Q348<100,Q348>=25)),坐班!E$12,
IF(OR(X348="是",K348=坐班!B$4,AND(Q348<25,Q348>=20)),坐班!E$13,
IF(AND(Q348<20,Q348>=15),坐班!E$14,
IF(AND(Q348<15,Q348>=10),坐班!E$15,IF(AND(Q348<10,Q348>=1),坐班!E$16,""))))),""))