Problem with Nested IF Function?

Hello All, hope you're well!

Of I have a formula I need, I'm not sure if it's possible as I can't even get my head round it on paper let alone a spreadsheet.

Ok, I have 3 Columns...

D = Is either Blank or Displays a Date

E = Displays either YES or NO

F = Displays either YES or NO

G = Displays YES or NO
H = Displays YES or NO

I = Displays YES or NO

Right, I need a formula that says...

If Column D is Blank, as well as column E and F display the text "MAKE FIRST CONTACT"

If Column D has a Value but Column E and F are Blank, display the text "AWAITING RESPONSE"

If Column D has a Value AND Column E is NO and Column F is Blank, and Columns G,H and I are Blank, display the text "SEND FOLLOW UP EMAIL"

If Column D has a Value AND Column E is YES and Column F is NO, and Columns G,H and I are Blank, display the text "ENCOURAGE REGISTRATION"

If Column D has a Value AND Column E is YES and Column F is YES, and Columns G,H and I are Blank, display the text "PLAN ABOUT US"

If Column D has a Value AND Column E is YES and Column F is YES AND Column G is YES but Column H and I are NO, display the text "MARKETING EMAIL"

If Column D has a Value AND Column E is YES and Column F is YES AND Column G and H are YES but Column I is NO, display the text "PROMO IMAGE"

If Column D has a Value AND Column E is YES and Column F is YES AND Column G and H are YES and Column I is YES, display the text "SUCCESS!"

The text will be displayed in column J!

Many thanks,

Anna

i'm sure this can be further simplified

=IF(AND(D2="",E2="",F2=""),"MAKE FIRST CONTACT",IF(AND(D2<>"",E2="",F2=""),"AWAITING RESPONSE",IF(AND(D2<>"",E2="NO",F2="",G2="",H2="",I2=""),"SEND FOLLOW UP EMAIL",IF(AND(D2<>"",E2="YES",F2="NO",G2="",H2="",I2=""),"ENCOURAGE REGISTRATION",IF(AND(D2<>"",E2="YES",F2="YES",G2="",H2="",I2=""),"PLAN ABOUT US",IF(AND(D2<>"",E2="YES",F2="YES",G2="YES",H2="NO",I2="NO"),"MARKETING EMAIL",IF(AND(D2<>"",E2="YES",F2="YES",F2="YES",G2="YES",H2="YES",I2="NO"),"PROMO IMAGE",IF(AND(D2<>"",E2="YES",F2="YES",G2="YES",H2="YES",I2="YES"),"SUCCESS!","No Criteria"))))))))

Try this...
N2:O8 contains this list:

Please Login or Register  to view this content.

Now you can use this regular formula

Please Login or Register  to view this content.

Is that something you can work with?