导读 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,"")。