无意中发现了一个新的substitute方法可以列举所有组合,这样公式就大幅简化了,运算也更快了。
定义名称EV: =LAMBDA(x,EVALUATE(x)
=LET(p,UNIQUE(REDUCE(REDUCE({"((A#A)#A)#A";"(A#(A#A))#A";"(A#A)#(A#A)";"A#((A#A)#A)";"A#(A#(A#A))"},{1,2,3},LAMBDA(s,n,TOCOL(SUBSTITUTE(s,"#",{"+","-","*","/"},1)))),{1,2,3,4},LAMBDA(s,n,LET(p,INDEX(B3:E3,n),TOCOL(SUBSTITUTE(s,"A",p,SEQUENCE(,5-n)))))))&"="&G3,FILTER(p,IFERROR(EV(p),),"无解"))
定义名称EV: =LAMBDA(x,EVALUATE(x)
=LET(p,UNIQUE(REDUCE(REDUCE({"((A#A)#A)#A";"(A#(A#A))#A";"(A#A)#(A#A)";"A#((A#A)#A)";"A#(A#(A#A))"},{1,2,3},LAMBDA(s,n,TOCOL(SUBSTITUTE(s,"#",{"+","-","*","/"},1)))),{1,2,3,4},LAMBDA(s,n,LET(p,INDEX(B3:E3,n),TOCOL(SUBSTITUTE(s,"A",p,SEQUENCE(,5-n)))))))&"="&G3,FILTER(p,IFERROR(EV(p),),"无解"))



