EXCEL中if函数多个条件包括日期、数值和文本,应该怎么写答:=IF(E3>=200,"是",IF(AND(D3<="4月11日",E3<200),"否",IF(AND(D3>"4月11日",E3<200,C3="在职"),"继续观察","否")))
IF函数,要以2个日期作条件答:b6 =if(and(b2>date(2012,1,1),b2<=today()-date(today())),j6,"")如果是大于1月(从2月1日开始),改为:=if(and(b2>date(2012,2,0),b2<=today()-date(today())),j6,"")
EXCEL中IF函数多条件日期如何设置答:=IF(AND(I3>=DATE(2010,1,1),I3<=DATE(2010,6,30)),"120",IF(I3>=DATE(2010,7,1),"无",IF(I3<DATE(2010,1,1),"240")))