为民为世 发表于 2021-12-7 09:10:52

除法和括号怎么算？

能源藻类 发表于 2021-12-8 01:28:28

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D$1,"-","+-"),"*","+"),"/","+"),"+",REPT(" ",100)),ROW(A1)*100-98,100))

陈志江 发表于 2021-12-14 03:10:07


如附件，用POWERQUERY做的，支持乘法拆开

小小先森 发表于 2021-12-21 05:36:43


新函数搞定

学习雷锋好榜样 发表于 2021-12-22 10:07:03

冬哥，牛B

猩人福利 发表于 2021-12-23 09:28:59

=IFNA(LOOKUP(9999,--LEFT(LOOKUP(A4,MMULT(-(ROW($1:$99)>=COLUMN(A:CU)),-TEXT(RIGHT(SUBSTITUTE(9999999&TRIM(MID(SUBSTITUTE(SUBSTITUTE("+"&MID(FORMULATEXT(A$1),2,999),"-","+"),"+",REPT(" ",99)),ROW($1:$99)*99-98,99)),"*",REPT(" ",20)),6),"[<99];1")),MID("+"&MID(FORMULATEXT(A$1),2,999),FIND("@",SUBSTITUTE(SUBSTITUTE("+"&MID(FORMULATEXT(A$1),2,999),"-","+"),"+","@",ROW($1:$99))),8)),ROW($1:$8))),"")

好多年没整这么长的公式了，就不简化了。

梦醒了心碎了 发表于 2021-12-23 10:49:38

=LOOKUP(10^9,--MID(D$1,SMALL(IF(ISERR(-(0&MID(D$1,ROW($1:$299),1))),ROW($1:$299),999),ROW(A1))+(ROW(A1)=1),ROW($1:$9)))

阿洛舒华 发表于 2021-12-27 20:59:15

顺通达 发表于 2022-1-8 08:48:54

=IFNA(LOOKUP(9999,--LEFT(LOOKUP(A4,MMULT(-(ROW($1:$99)>=COLUMN(A:CU)),-TEXT(RIGHT(SUBSTITUTE(9999999&TRIM(MID(SUBSTITUTE(SUBSTITUTE("+"&MID(FORMULATEXT(A$1),2,999),"-","+"),"+",REPT(" ",99)),ROW($1:$99)*99-98,99)),"*",REPT(" ",20)),6),"[<99];1")),MID("+"&MID(FORMULATEXT(A$1),2,999),FIND("@",SUBSTITUTE(SUBSTITUTE("+"&MID(FORMULATEXT(A$1),2,999),"-","+"),"+","@",ROW($1:$99))),8)),ROW($1:$8))),"")

好多年没整这么长的公式了，就不简化了。

哥哥的后半生 发表于 2022-1-10 04:34:56

=LOOKUP(10^9,--MID(D$1,SMALL(IF(ISERR(-(0&MID(D$1,ROW($1:$299),1))),ROW($1:$299),999),ROW(A1))+(ROW(A1)=1),ROW($1:$9)))
页: 1 2 [3] 4
查看完整版本: 在给定的单元格计算式中依次提取数字