If函数大于一个数在小于一个数怎么取中间值 啊 ,

2024-12-02 10:41:59
推荐回答(2个)
回答1:

=IF(AND(D4="1693A",M2>=1.22,M2<=1.25),"异常","OK"))

回答2:

=IF(M2<1.22,"OK",IF(M2>1.25,"OK","异常"))