問題已解決
麻煩會(huì)的老師回一下!毛利對(duì)應(yīng)的毛利區(qū)間,怎么用公式正確匹配!謝謝老師
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
同學(xué)請(qǐng)稍等,我在工作表寫下公式發(fā)你
2023 04/13 11:57
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784994 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 04/13 12:00
好的,等你的答案,謝謝啦
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784994 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 04/13 12:27
出來沒,怎么匹配呢
陳艷平 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 04/13 12:29
用if函數(shù),把判斷條件都寫進(jìn)去
陳艷平 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 04/13 12:29
適用你數(shù)據(jù)量比較大的
陳艷平 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 04/13 12:30
如果你的數(shù)據(jù)量不大,直接篩選不同數(shù)值段匹配就可以
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784994 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 04/13 12:30
你試了確定是可以嗎?
陳艷平 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 04/13 12:31
其他的判斷條件都填充進(jìn)去
![](/wenda/img/newWd/sysp_btn_eye.png)