二數相乘後加總 (10266)

日期：


C2=SUM(MID(SUBSTITUTE(SUBSTITUTE(B2,"+","*"),"*",REPT(" ",99)),{1,3}*99-98,99)*MID(SUBSTITUTE(SUBSTITUTE(B2,"+","*"),"*",REPT(" ",99)),{2,4}*99-98,99))


留言

張貼留言