EXCEL公式求助（见附件）

关键字：公式 更新时间：2020-01-21 12:42:50 131次访问

=EVALUATE(ABS(EVALUATE(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"),FIND("A",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))-1))-EVALUATE(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"),FIND("{",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))+1,FIND("}",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))-FIND("{",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))-1)))&RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))-FIND("}",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"{","",1),"}","A",1),",","+"))))

相关标签：公式