202206291550總和 (10154)

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)))))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank