Excel @if Problems I have a very simple problem that I just can\'t get to work .

Question

Excel @if Problems

I have a very simple problem that I just can't get to work ...

I have a Contract date in column C
The Return date in column D =c5=30
Today in column E Today()
How many days left in column F =IF(C9,"", D9-E9)
How many days out in Column G =IF(F5>6,"","Days Out")
Call Client in Column H =IF(F5>6,"","Follow-up ~ Call Client")
The problem ...
If I don't have a date in Column C - I don't want to see anything in Column F
So I put =if(c5,"",D5-E5)
it gives me a -42001 instead of leaving the cell blank...

and I want it to say if F5 is less that 0 Expired !

Explanation / Answer

hello ,,

try

oops, I didnt realize your formula is in column F, it should be

=IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.