当前位置: 动力学知识库 > 问答 > 编程问答 >

Excel If Statement- Need to show "blank" in blank cell

问题描述:

 Cell A1= Target Date - 1/1/13

Cell B1= Completion Date - 1/15/13

Cell C1= Returns "Closed within 30 days"

I am trying to use the If Statement to return the word "blank" if a cell in column C1 is empty.

Here is what I have so far.

 =IF(B1>A1+30,"",Closed within 30 days")

Thank you

网友答案:

I am trying to use the If Statement to return the word "blank" if a cell in column C1 is empty.

Try = If(IsEmpty(C1),"Blank","Not Blank"))

网友答案:

Actually I think I understand your question now; what you want is when cell A1 or B1 is blank it should return "Blank".

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"Blank",IF(B1>A1+30,"","Closedwithin30days"))
分享给朋友:
您可能感兴趣的文章:
随机阅读: