excel
假设A列存储着数字，我们可以使用
excel的函数来计算面积和亩数。以下是一些示例公式：要计算面积：=SUBSTITUTE(LEFT(A2,FIND("/",A2)-1), "m2", ) + SUBSTITUTE(LEFT(A3,FIND("/",A3)-1), "m2", ) / SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("/",A2)), "亩", ) + SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("/",A3)), "亩", )要计算亩数：=SUBSTITUTE(LEFT(A2,FIND("/",A2)-1), "m2", ) + SUBSTITUTE(LEFT(A3,FIND("/",A3)-1), "m2", ) / (SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("/",A2)), "亩", ) + SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("/",A3)), "亩", ))如果要在同一个单元格中得出结果，可以使用以下公式：=SUBSTITUTE(LEFT(A2,FIND("/",A2)-1), "m2", ) + SUBSTITUTE(LEFT(A3,FIND("/",A3)-1), "m2", ) / (SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("/",A2)), "亩", ) + SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("/",A3)), "亩", ))
