如何在excel中用函数公式,判断下面二组编码所使用的类别。具体公式请高...答:=IF(ISNUMBER(FIND(LEFT(A2,1),"fpqz")),4,IF(ISNUMBER(MATCH(A2,{985238511696,985238511699,985239511684,985239695},0)),2,IF(LEFT(A2,3)="987",IF(LEFT(RIGHT(A2,6),1)="7",4.1,3.8),IF(AND(LEFT(A2,3)="986",LEFT(RIGHT(A2,6),3)="740"...