问题已解决
讓老師幫我做一下表格函數(shù)實現(xiàn)A列包含1T并且D列等于60會返回48,如果A2包含1T并且D列等于50返回30
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
您好!很高興為您解答,請稍等
2024 04/26 16:28
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 16:33
您好,試一下這個公式 哈
IFERROR(IF(AND(FIND(\\"IT\\",A3),D3=60,\\"48\\",IF(AND(FIND(\\"IT\\",A3),D3=50,\\"30\\")),\\"\\")
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 16:51
老師,不行說″您輸入的公式存在錯誤
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 16:56
您好,亂碼了,我發(fā)出來不是這樣的,我?guī)墙貓D吧
IFERROR(IF(AND(FIND(IT,A3),D3=60,48,IF(AND(FIND(IT,A3),D3=50,30)),)
FAILED
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 17:01
不行老師,我也是這么設(shè)的顯示還是錯誤
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 17:04
您好,50和60后面加上括號呢,因為我沒有表格,我是看這個理解起來寫公式的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 17:24
加上括號可以但是老師如A列有1T和3T,用這種方法就沒有辦法顯示了
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 17:25
您好,您的表格能發(fā)扣扣郵箱401566729么,我寫好后回復(fù)您
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 17:29
好的,老師,這是您QQ郵箱嗎
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 17:30
朋友 您好,是的,郵件發(fā)送后在這里跟我說一下哈,
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 17:48
老師郵件已發(fā),謝謝您?。?!
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 17:56
好的好的,我一會郵件回復(fù)您哈
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 17:57
好的,老師
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 18:03
朋友您好,郵件我收到了,稍等下下哈,我去寫一下
![](http://member.chinaacc.com/homes/resources/images/home/avatar/2.jpg)
84784972 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 04/26 18:24
老師我看到了,但是下面3T和300KG都顯示不出來了
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 04/26 18:33
您好,您看3T和300KG后面都滿足不了您給的條件的
![](/wenda/img/newWd/sysp_btn_eye.png)