kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 918
- Office Version
- 365
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
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
Excel Formula:
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 !!"))