=IF(AND(M9>=0,VALUE(G9)>=0),VALUE(G9)-M9,IF(AND(M9<=0,VALUE(G9)<=0),VALUE(G9)+M9,IF(AND(M9>=0,VALUE(G9)<=0),VALUE(G9)+M9,IF(AND(M9<=0,VALUE(G9)>=0),VALUE(G9)-M9,"错误"))))
=VALUE(IF(ISNUMBER(FIND("cm",L2)),SUBSTITUTE(L2,"cm"," ")))/100
=IF(AND(M2>=0,VALUE(G2)>=0),VALUE(G2)-M2,IF(AND(M2<=0,VALUE(G2)<=0),VALUE(G2)+M2,IF(AND(M2>=0,VALUE(G2)<=0),VALUE(G2)+M2,IF(AND(M2<=0,VALUE(G2)>=0),VALUE(G2)-M2,"错误"))))
1、VALUE(G9)将字符串转为数字
2、AND(M9>=0,VALUE(G9)>=0)同时满足条件1、2为真
3、ISNUMBER(FIND("cm",L2))判断字符串是否包含"cm"
4、SUBSTITUTE(L2,"cm"," ")替换字符"cm"为" "