使用技巧
1、單條件判斷返回值
=IF(A1>20,"完成任務","未完成")
2、多重條件判斷
=IF(A1=蔵","現金",IF(A1=","應收票據",IF(A1=1403,"原材料")))
注:多條件判斷時,注意括號的位置,右括號都在最後,有幾個IF就輸入幾個右括號。
3、多區間判斷
=IF(A1<60,"不及格",IF(A1<80,"良好","優秀"))
=IF(A1>=80,"優秀",IF(A1>=60,"良好","不及格"))
注:IF在進行區間判斷時,數字一定要按順序判斷,要麼升要不降