-
發表於:2024-03-21
使用技巧1、單條件判斷返回值=IF(A1>20,"完成任務","未完成")2、多重條件判斷=IF(A1=蔵","現金",IF(A1=񓒁","應收票據",IF(A1=1403,"原材料&#...
-
發表於:2024-03-21
ifor函數使用方法1、單條件判斷返回值=IF(A1>20,"完成任務","未完成")2、多重條件判斷=IF(A1=蔵","現金",IF(A1=񓒁","應收票據",IF(A1=1403,"...
-
發表於:2024-03-21
ifor函數的使用方法,具體如下:打開要進行處理的excel,OR函數格式:【OR(參數1,參數2,...)】,OR函數使用:【如果任意參數正確則返回true,否則返回false】,在輸入欄輸入:【IF(OR(C2>90,D2>90),"優...
-
發表於:2024-04-10
用法:1、單條件判斷返回值=IF(A1>20,"完成任務","未完成")2、多重條件判斷=IF(A1=蔵","現金",IF(A1=񓒁","應收票據",IF(A1=1403,"原材料"))...
-
發表於:2024-02-06
使用方法1、單條件判斷返回值=IF(A1>20,"完成任務","未完成")2、多重條件判斷=IF(A1=蔵","現金",IF(A1=񓒁","應收票據",IF(A1=1403,"原材料&#...