問(wèn)題已解決
老師幫我做下這個(gè)公式,用IF做出這個(gè)危險(xiǎn)程度和等級(jí),以圖中范圍
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
IF(B3<=20,稍有危險(xiǎn),可以接受,IF(B3<=70,一般危險(xiǎn)需要控制,IF(B3<=160,顯著危險(xiǎn)重點(diǎn)控制,IF(B3<=320,高度危險(xiǎn),需要立即改善,極其危險(xiǎn),不能繼續(xù)作業(yè)))));IF(B3<=20,Ⅰ,IF(B3<=70,Ⅱ,IF(B3<=160,Ⅲ,IF(B3<=320,Ⅳ,Ⅴ))))
2022 07/14 17:37
依然老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 07/14 17:43
危險(xiǎn)程度和等級(jí)那些,兩頭要加英文輸入法下的雙引號(hào),我再excel表上試過(guò)無(wú)誤,貼出來(lái)雙引號(hào)看不到了
![](/wenda/img/newWd/sysp_btn_eye.png)