Excel Problem

Use =if(c5>0,"",D5-E5) instead

How can I use an =if and OR function?
I have a formula =IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))
I want it to also say, if there is a date in K5 leave cell C5 blank
I tried to put an OR after the 1st =if but it doesn't work

Not exactly sure what you are trying to do, but if you want to leave the cell blank if either C5 or K5 is empty, you could use

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

In cell F5 I want to say
if c5 is blank leave it blank, or if cell k5 has a date in it, leave it blank, if not do the rest of the formula

What it is, is Cell c5 is a date
D5 is =IF(C5="","",C5+30)
E5 is Today()
F5 is =IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))

Sometimes I put a date in cell K5
If I put a date in K5 I don't want F5 to say Expired, I want it to either be blank or maybe say Received

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

Nope, doesn't work ... it leaves it blank if there is nothing in K5 or a date like 2/2/14.

Try

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

Nope, doesn't work, same result! I've tried and tried ...
It's still blank - I copied and pasted just to make sure I'm not messing up!

I opened Excel and used this. It seems to do what I think you want.

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

Yessssssssssss You're the best!