excel怎样让满足条件的变为数字答:A6输入 =IF(OR(--MID(A2,1,1)={1,2,3,5,7}),"质","合")&IF(OR(--MID(A2,2,1)={1,2,3,5,7}),"质","合")&IF(OR(--MID(A2,3,1)={1,2,3,5,7}),"质","合")&IF(OR(--MID(A2,4,1)={1,2,3,
EXCEL中怎样用公式转换数字答:g1=ISNUMBER(FIND(A1,"4,9"))*1+ISNUMBER(FIND(A1,"3,8"))*2+ISNUMBER(FIND(A1,"1,6"))*3+ISNUMBER(FIND(A1,"2,7"))*4+ISNUMBER(FIND(A1,"0,5"))*5下、右拉