技术贴:书写高度复杂公式的思路用了宏表函数,wps直接把EV换成evaluate就行
=LET(p,UNIQUE(REDUCE(0,REDUCE({"((A#A)# A)#A";"(A# (A#A))# A";"(A#A)# (A#A)";"A# ((A#A)# A)";"A#(A# (A#A))"},ROW(1:3),LAMBDA(s,n,TOCOL(SUBSTITUTE(s,"#",{"+","-","*","/"},1)))),LAMBDA(s,n,VSTACK(s,MAP(REDUCE(1,ROW(2:4),LAMBDA(s,n,TOCOL(REPLACE(s,SEQUENCE(,n),,n)))),LAMBDA(x,TEXTJOIN(INDEX(E5:H5,MID(x,{1,2,3,4},1)),0,TEXTSPLIT(n,"A"))))))))&"=24",FILTER(p,IFERROR(EV(p),),"无解"))