excel表格两个数如何算

1.在excel中如何分别计算一个单元格里面的两个数字

B1公式：

=-LOOKUP(,-LEFT(A1,{1,2,3,4,5,6}))*2&IF(COUNTIF(A1,"*(*"),"(","/")&-LOOKUP(,-LEFT(MID(A1,MIN(FIND({"(","/"},A1&"(/"))+1,15),{1,2,3,4,5}))*2&IF(COUNTIF(A1,"*(*"),")","")

下拉填充