202212031822運算式 加減乘除 (10827)

二個 "*" 有誤

 

C1{=SUM(IFERROR((IF(ISERR(FIND("/",TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","+-"),"+","*1+"),"+","*"),"*",REPT(" ",59)),(ROW($1:$9)*2-1)*59-58,59)))),"","0 ")&TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","+-"),"+","*1+"),"+","*"),"*",REPT(" ",59)),(ROW($1:$9)*2-1)*59-58,59)))*(IF(ISERR(FIND("/",TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1&"+","-","+-"),"+","*1+"),"+","*"),"*",REPT(" ",59)),(ROW($1:$9)*2)*59-58,59)))),"","0 ")&TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1&"+","-","+-"),"+","*1+"),"+","*"),"*",REPT(" ",59)),(ROW($1:$9)*2)*59-58,59))),))

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