Formula needing help with. (IFs, ANDs, ORs)

I need an Excel formula for the following problem:

If cell E2 has an "X" in it and there is a date in F2 then it is "Complete". If cell E2 has an "X" in it and F2 does not have a date in it, it is "Incomplete". If there is not an "X" in cell E2 then it is "Null"

I am using MS Excel 2010. Please help, I have spent hours trying to figure this out to no avail.

Try

=IF(E2="X",IF(ISNUMBER(F2),"Complete","Incomplete"),"")

Originally Posted by Tony Valko

Maybe this...

=IF(E2="X",IF(COUNT(F2),"Complete","Incomplete"),"")

Awesome, thank you so much! This worked beautifully!