Excel ISNA或ISERROR問題

excel

johannachang1004 2021-07-16 11:10:27 ‧ 759 瀏覽

分享至

請問請問要如何調整公式=IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",IF(AND(LEFT(A4,4)="易燃液體",C4<-20,D4<40),"50公升")&"/"))，答案才不會出現FALSE/，可以"-/"取代?

登入發表討論

直播研討會

{{ item.channelVendor }} {{ item.webinarstarted }} |

直播中

1 個回答

海綿寶寶

iT邦大神 1 級 ‧ 2021-07-16 12:14:49

最佳解答

試試看

=IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",IF(AND(LEFT(A4,4)="易燃液體",C4<-20,D4<40),"50公升","-/")))

另外給個建議
輸入公式時要先輸入完整的括號
再去輸入裡面的內容
這樣比較不會錯亂
以上面的公式為例：

1.IF(TRUE,"/","")
2.IF(ISNA(),"/","")
3.IF(ISNA(LEFT(A4,4)="易燃液體"),"/","")
4.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(TRUE,"50公升",""))
5.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(),"50公升",""))
6.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",""))
7.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",IF(TRUE,"50公升","")))
8.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",IF(AND(),"50公升","")))
9.IF(ISNA(LEFT(A4,4)="易燃液體"),"/",IF(AND(LEFT(A4,4)="易燃液體",B4<100),"50公升",IF(AND(LEFT(A4,4)="易燃液體",C4<-20,D4<40),"50公升","-/")))