xls
=HEX2DEC(A1) =A1&B1 =SUBSTITUTE(A2,"#","") =LEFT(H1,7) 转换 连接 替代 截取
=IF(E2=11、IF(E2=一(二)IF(E2=13.IF(E2=21、IF(E2=二(二)IF(E2=31、IF(E2=三(二)IF(E2=三、三IF(E2=41、IF(E2=四(二)IF(E2=43.IF(E2=51、IF(E2=五(二)IF(E2=“五（3）”,53,IF(E2=61，IF(E2=六(二)IF(E2=六(三)IF(E2=六(四)))))))))))))))))))
vs
=IF(LEFT(E2,1)=“一”,1,IF(LEFT(E2,1)=“二”,2,IF(LEFT(E2,1)=“三”,3,IF(LEFT(E2,1)=“四”,4,IF(LEFT(E2,1)=“五”,5,IF(LEFT(E2,1)=)))
=RIGHT(LEFT(E2,3),1)
=G2*10 H2