EXCEL里面IF函数,今天减去交货日期,有3个条件,需要给3个值答:公式为:=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","剩余3天以上"))=IF(A2-TODAY()<1,"已交货",IF(A2-TODAY()<4,"即将到期","还剩"&A2-TODAY()&"天"))如图所示:
EXCEL中if函数多个条件包括日期、数值和文本,应该怎么写答:=IF(E3>=200,"是",IF(AND(D3<="4月11日",E3<200),"否",IF(AND(D3>"4月11日",E3<200,C3="在职"),"继续观察","否")))