Question

如图,已经输出A1-A4,B1-B4数据公式,要求在C列分别用+-*/四种关系合并同行的A列和B列,

Answer 1

笨笨的公式:

=IF(MID(C1,FIND(")",C1)+1,1)="+",(LEFT(A1,1)+RIGHT(A1,1))+(LEFT(A1,1)*RIGHT(A1,1)),IF(MID(C1,FIND(")",C1)+1,1)="-",(LEFT(A1,1)+RIGHT(A1,1))-(LEFT(A1,1)*RIGHT(A1,1)),IF(MID(C1,FIND(")",C1)+1,1)="/",(LEFT(A1,1)+RIGHT(A1,1))/(LEFT(A1,1)*RIGHT(A1,1)),(LEFT(A1,1)+RIGHT(A1,1))*(LEFT(A1,1)*RIGHT(A1,1)))))