Return value based on crietria

[kumara_faith]

HI,

I have the following table:
ColumnB ColumnC ColumnD ColumnE

I am trying to insert a message in column F. The criteria are as follows:

1)If cell in column D and E is empty, then say Email and PC name is blank.
2) If only cell in column D is empty, say Email is blank.
3) If only cell in column E is empty, say PC name is blank
4) If both cell in column D and E is filles, say All Completed- Great Job

I tried using the following formula but I am not getting it right. Appreciate any help

IF(COUNTIFS(D3:E3)<2,"Email and PC Name is blank !!",IF(COUNTA(D3)=0,"Email is blank!!",IF(COUNTA(E3)=0,"PC Name is blank!!,"All Complete- Great Job !!"))

 

[AlphaFrog]

=IF(AND(D2="",E2=""),"Email and PC name are blank",IF(D2="","Email is blank",IF(E2="","PC name is blank","All Completed- Great Job")))

 

[kumara_faith]

Thank you AlphaFrog. That worked. Appreciate it.