求体积.xls

产品编号产品规格体积 A001 长250 宽120 高20600000 250*120*20 A002 长128 宽100 高25320000 128*100*25 A003 宽88高17135388 *88*17 =SUMPRODUCT( --MID(B2,FIND(" 长",B2)+1,FIND(" 宽",B2) -FIND(" 长",B2) -1), --MID(B2,FIND(" 宽",B2)+1,FIND(" 高",B2) -FIND(" 宽",B2) -1), --RIGHT(B2,LEN(B2) -FIND(" 高",B2))) =PRODUCT( --MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," 宽",REPT(" ",100))," 高",REPT(" ",100))," 长",REPT(" ",100)),{100,200,300},15)) =PRODUCT(MID(B2,FIND(" 长",B2)+1,FIND(" 宽",B2) -FIND(" 长",B2) -1),MID(B2,FIND(" 宽",B2)+1,FIND(" 高",B2) -FIND(" 宽",B2) -1),RIGHT(B2,LEN(B2) -FIND(" 高",B2))) =evaluate(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," 长","")," 宽","*")," 高","*")) =SUMPRODUCT( --MID(B2,FIND(" 长",B2)+1,FIND(" 宽",B2) -FIND(" 长",B2) -1), --MID(B2,FIND(" 宽",B2)+1,FIND(" 高",B2) -FIND(" 宽",B2) -1), --RIGHT(B2,LEN(B2) -FIND(" 高",B2))) =PRODUCT( --MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," 宽",REPT(" ",100))," 高",REPT(" ",100))," 长",REPT(" ",100)),{100,200,300},15)) =PRODUCT(MID(B2,FIND(" 长",B2)+1,FIND(" 宽",B2) -FIND(" 长",B2) -1),MID(B2,FIND(" 宽",B2)+1,FIND(" 高",B2) -FIND(" 宽",B2) -1),RIGHT(B2,LEN(B2) -FIND(" 高",B2))) =evaluate(SUBSTITUTE(SUBSTITUTE(SUBSTITU