Question

excel if函数的应用问题（增加if条件）

excel if函数的应用问题 B2中的函数为 =IF(AND(A2-TODAY()<=180,A2-TODAY()>0),"将过期",IF(A2-TODAY()>180,"正常",IF(A2-TODAY()<=0,"过期",""))) ，将B2函数下拉复制到B3和B4后，但A3中无数据，B3仍显示为过期，B3显示的结果不符合逻辑。
目的：在原函数上再增加一个if条件，做到“判断A3为空白”的时候，则B2显示为空白。
期待高手解答！谢谢！

Answer 1

=IF(IF(A2="","",(AND(A2-TODAY()<=180,A2-TODAY()>0),"将过期",IF(A2-TODAY()>180,"正常",IF(A2-TODAY()<=0,"过期",""))) )

Answer 2

=IF(A2="","",IF(AND(A2-TODAY()<=180,A2-TODAY()>0),"将过期",IF(A2-TODAY()>180,"正常","过期")))

Answer 3

把
IF(A2="","",
加到前面，并注意括号配对好。

Answer 4

公式可简化为:
=if(a2="","",if(today()<a2-180,"正常",if(today()<a2,"将过期","过期")))