Question

excel if函数的应用问题(增加if条件)

excel if函数的应用问题(增加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(ISBLANK(A2),"",IF(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,"正常",IF(A2-TODAY()<=0,"过期",""))))

应该直接在加个if就可以　的。

Answer 3

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

Answer 4

IF(A2-TODAY()<=0,"过期"," ")))

过期后面那个“”

“空格”

Answer 5

=IF(A2="","",IF(你的原公式）