計算加與乘 除去括号 (10644)

日期：


C2=LOOKUP(1,0/FIND({"+","*"},B2),IF({1,0},SUM(MID(SUBSTITUTE(SUBSTITUTE(MID(B2,2,9),")",),"+",REPT(" ",9)),{1,10},9)*1),PRODUCT(MID(SUBSTITUTE(SUBSTITUTE(MID(B2,2,9),")",),"*",REPT(" ",9)),{1,10},9)*1)))


留言

張貼留言