如下
=ROUND(IF(LEN(O4)-LEN(SUBSTITUTE(O4,"*",""))>2,(LEFT(O4,FIND("*",O4)-1)/1000+MID(O4,FIND("*",O4)+1,FIND("*",O4,FIND("*",O4)+1)-FIND("*",O4)-1)/1000)*MID(O4,FIND("*",O4,FIND("*",O4)+1)+1,FIND("*",O4,FIND("*",O4,FIND("*",O4)+1)+1)-FIND("*",O4,FIND("*",O4)+1)-1)/1000*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))/2*7.85,IF(ISNUMBER(SEARCH("▲",O4)),LEFT(SUBSTITUTE(O4,"▲",""),FIND("*",SUBSTITUTE(O4,"▲",""))-1)/1000*1.732*LEFT(SUBSTITUTE(O4,"▲",""),FIND("*",SUBSTITUTE(O4,"▲",""))-1)/1000/2/2*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85,IF(ISNUMBER(SEARCH("Φ",O4)),LEFT(SUBSTITUTE(O4,"Φ",""),FIND("*",SUBSTITUTE(O4,"Φ",""))-1)/1000/2*LEFT(SUBSTITUTE(O4,"Φ",""),FIND("*",SUBSTITUTE(O4,"Φ",""))-1)/1000/2*3.1416*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85,LEFT(O4,FIND("*",O4)-1)/1000*MID(O4,FIND("*",O4)+1,FIND("*",O4,FIND("*",O4)+1)-FIND("*",O4)-1)/1000*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85))),2)
PS:用的是WPS
=ROUND(IF(LEN(O4)-LEN(SUBSTITUTE(O4,"*",""))>2,(LEFT(O4,FIND("*",O4)-1)/1000+MID(O4,FIND("*",O4)+1,FIND("*",O4,FIND("*",O4)+1)-FIND("*",O4)-1)/1000)*MID(O4,FIND("*",O4,FIND("*",O4)+1)+1,FIND("*",O4,FIND("*",O4,FIND("*",O4)+1)+1)-FIND("*",O4,FIND("*",O4)+1)-1)/1000*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))/2*7.85,IF(ISNUMBER(SEARCH("▲",O4)),LEFT(SUBSTITUTE(O4,"▲",""),FIND("*",SUBSTITUTE(O4,"▲",""))-1)/1000*1.732*LEFT(SUBSTITUTE(O4,"▲",""),FIND("*",SUBSTITUTE(O4,"▲",""))-1)/1000/2/2*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85,IF(ISNUMBER(SEARCH("Φ",O4)),LEFT(SUBSTITUTE(O4,"Φ",""),FIND("*",SUBSTITUTE(O4,"Φ",""))-1)/1000/2*LEFT(SUBSTITUTE(O4,"Φ",""),FIND("*",SUBSTITUTE(O4,"Φ",""))-1)/1000/2*3.1416*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85,LEFT(O4,FIND("*",O4)-1)/1000*MID(O4,FIND("*",O4)+1,FIND("*",O4,FIND("*",O4)+1)-FIND("*",O4)-1)/1000*TRIM(RIGHT(SUBSTITUTE(O4,"*",REPT(" ",LEN(O4))),LEN(O4)))*7.85))),2)
PS:用的是WPS