EXCEL几个简单的函数
=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"," ")))/1
原创
2021-12-10 17:50:13 ·
303 阅读 ·
0 评论