EXCEL公式求助（见附件）

更新时间2020-01-21 12:42:50

=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),",","+"))))

相关标签:公式