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")))
EXCEL中if函数多个条件包括日期、数值和文本,应该怎么写答:=IF(E3>=200,"是",IF(AND(D3<="4月11日",E3<200),"否",IF(AND(D3>"4月11日",E3<200,C3="在职"),"继续观察","否")))