-
发表于: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-04-10
用法: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-02-06
使用方法1、单条件判断返回值=IF(A1>20,"完成任务","未完成")2、多重条件判断=IF(A1=蔵","现金",IF(A1=񓒁","应收票据",IF(A1=1403,"原材料&#...