F3=SUMPRODUCT(LEFT(A3:E3,FIND("*",A3:E3&"*")-1)*TEXT(MID(A3:E3,FIND("*",A3:E3&"*")+1,9),"0;;;!1"))
另解=SUM(10^MMULT({1,1},LOG(TEXT({1;-1}%,SUBSTITUTE(A3:E3&"*1","*",";")))))
另解=SUM(EXP(MMULT({1,1},LN(TEXT(MID(SUBSTITUTE(A3:E3,"*",REPT(" ",9)),{1;9},9),"0;;;!1")))))
另解=SUM(EXP(MMULT({1,1},LN(--MID(SUBSTITUTE(A3:E3&"*1","*",REPT(" ",9)),{1;9},9)))))
留言
張貼留言