Formula Help : IF(ISBLANKK) - Second part not working

.
The following formula works great for E2 but fails to display "Incomplete" if F2 is blank.

Please Login or Register  to view this content.

The formula is in cell K2.

Please help. Thank you.

Copied "as is" and it works

May be just

=IF(J2="","",IF(E2="","Incomplete",IF(F2="","Incomplete","")))

="" is empty string but not blank
blank = null

E2 and F2 each have date and time - no formulas.

I've tried deleting cell K2 and even deleting all of Column K and starting over. For some reason the formula isn't working for F2.

J2 has this formula :

Please Login or Register  to view this content.

Is this causing the issue ?

.
Root:

Your formula gives the same result here ... F2 blank doesn't cause Incomplete to show.

.
Here is the workbook :

Due to the formula in J2, if F2 is blank, then J2 is blank ( "" ).
Then the formula in H2 returns "" because =IF(J2="" is true.

Through a chain of formulas in your workbook, J2="" when F2="". Thus, no "Incomplete".

.
How do I edit the formula so K2 remains blank if there is nothing to 'compute' and still track if E2 or F2 is blank and show INCOMPLETE ?

Evaluate formula in steps

IF(""="","" ......

Maybe test F2 first...

.
This

Please Login or Register  to view this content.

results in the infamous #VALUE error.

Tried changing around E2 and F2 (which gets tested first) ... no go.

.
This formula :

Please Login or Register  to view this content.

dragged down the column results in this :

Excel 2007 32 bit

	E	F	G	H	I	J	K
1	First In	Last out	Production Time	Attendance	Break time	Work time	Comments
2	1/13/2018 8:00	1/13/2018 17:00	9:00:00	1	0:15:00	8:45:00
3	1/13/2018 17:00	1/14/2018 8:00	15:00:00	1	0:30:00	14:30:00
4							Incomplete
5							Incomplete
6							Incomplete
7							Incomplete
8							Incomplete
9							Incomplete
10							Incomplete

That is the part I'm trying to avoid.

Try
=IF(OR(E2="",F2=""),"Incomplete","")

.
This worked !

Please Login or Register  to view this content.

Does anyone see any potential issues with it ?

Ok, to prevent the incomplete filling the column..

=IF(B2="","",IF(OR(E2="",F2=""),"Incomplete",""))

.
Jonmo1:

Your last works great also !