EXL=IF(OR(C2="",E2=""),"",DATE(C2,E2,5))是什么意思=IF(K2="","",IF(K2>=$D$1,"",K2+1))呢?=IF(B1="","",DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)-1))呢?这是EXL中的函数..第一个是IF(OR(C2="",E2=""),"",DATE(C2,E2,5))
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/23 20:32:08
![EXL=IF(OR(C2=](/uploads/image/z/5483974-22-4.jpg?t=EXL%3DIF%28OR%28C2%3D%22%22%2CE2%3D%22%22%29%2C%22%22%2CDATE%28C2%2CE2%2C5%29%29%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%3DIF%28K2%3D%22%22%2C%22%22%2CIF%28K2%3E%3D%24D%241%2C%22%22%2CK2%2B1%29%29%E5%91%A2%3F%3DIF%28B1%3D%22%22%2C%22%22%2CDATE%28YEAR%28B1%29%2CMONTH%28B1%29%2B1%2CDAY%28B1%29-1%29%29%E5%91%A2%3F%E8%BF%99%E6%98%AFEXL%E4%B8%AD%E7%9A%84%E5%87%BD%E6%95%B0..%E7%AC%AC%E4%B8%80%E4%B8%AA%E6%98%AFIF%28OR%28C2%3D%22%22%2CE2%3D%22%22%29%2C%22%22%2CDATE%28C2%2CE2%2C5%29%29)
EXL=IF(OR(C2="",E2=""),"",DATE(C2,E2,5))是什么意思=IF(K2="","",IF(K2>=$D$1,"",K2+1))呢?=IF(B1="","",DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)-1))呢?这是EXL中的函数..第一个是IF(OR(C2="",E2=""),"",DATE(C2,E2,5))
EXL=IF(OR(C2="",E2=""),"",DATE(C2,E2,5))是什么意思
=IF(K2="","",IF(K2>=$D$1,"",K2+1))呢?
=IF(B1="","",DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)-1))呢?
这是EXL中的函数..第一个是IF(OR(C2="",E2=""),"",DATE(C2,E2,5))
EXL=IF(OR(C2="",E2=""),"",DATE(C2,E2,5))是什么意思=IF(K2="","",IF(K2>=$D$1,"",K2+1))呢?=IF(B1="","",DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)-1))呢?这是EXL中的函数..第一个是IF(OR(C2="",E2=""),"",DATE(C2,E2,5))
看看C2或E2是否为空的单元格,如果两者有一个为空,及为空,否则就是C2,E2,5组成C2年E2月5日
条件函数
c语言编程啊,这个还真看不懂。