excel如何带单位相乘(excel表格带单位相乘)

导读 C1公式 =IF(LEN(A1)-LEN(SUBSTITUTE(A1,"×",))=2,IF(LEN(A1)-LEN(SUBSTITUTE(A1,"×",))=2,LEFT(A1,FIND("×",A1)-1)*MID(A1,FIND("×",A...

C1公式 =IF(LEN(A1)-LEN(SUBSTITUTE(A1,"×",))=2,IF(LEN(A1)-LEN(SUBSTITUTE(A1,"×",))=2,LEFT(A1,FIND("×",A1)-1)*MID(A1,FIND("×",A1)+1,FIND("×",A1,FIND("×",A1)+1)-FIND("×",A1)-1)*RIGHT(A1,LEN(A1)-FIND("×",A1,FIND("×",A1)+1)),0)*B1/1000000,"")。

免责声明:本文由用户上传,如有侵权请联系删除!