D3{=SUM(IFERROR(MID(SUBSTITUTE(SUBSTITUTE(B3," ","*"),"*",REPT(" ",99)),(ROW($1:$9)*2-1)*99-98,99)*MID(SUBSTITUTE(SUBSTITUTE(B3," ","*"),"*",REPT(" ",99)),(ROW($1:$9)*2)*99-98,99),))
另解{=SUM(10^MMULT(IFERROR(LOG(--TEXT({1,-1}%,SUBSTITUTE(TRIM(MID(SUBSTITUTE(B3," ",REPT(" ",99)),ROW($1:$9)*99-98,99)),"*",";"))),-666),{1;1}))
另解{=SUM(10^MMULT(IFERROR(LOG(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(B3," ","*"),"*",REPT(" ",99)),(ROW($1:$9)*2-{1,0})*99-98,99))),-666),{1;1}))
留言
張貼留言