I am learning how to do formulas with multiple conditions in Excel, so by no means an expert.  I am trying to write a formula that accounts for 5 multiple conditions and I keep getting an error message.

Summary:

Column A is a date fieldColumn C has values of External or InternalColumn D has values of Application or No ApplicationColumn E has values of Not Due, Full and ModifiedColumns F, L-O can have date values or be blank, but the presence of a date drives the outcome.

Scenario I’m trying to write the formula for:

If the date in Column A < today’s date AND if C is “Internal” AND If D =”No Application” AND if E =”Modified”, AND if Columns F, N and O are not blank, then “Yes” ORIf the date in Column A > today’s date AND if C is “Internal” AND If D =”No Application” AND if E =”Not Due”, AND if Columns F, and O are not blank, then “Yes” ORIf the date in Column A is blank AND if C is “Internal” AND If D =”Application” AND if E =”Full”, AND if Columns F, L, M,N and O are not blank, then “Yes” ORIf the date in Column A > today’s date AND if C is “External” AND If D =”No Application” AND if E =”No”, AND if Columns F, and O are not blank, then “Yes” ORIf the date in Column A < today’s date or blank AND if C is “External” AND If D =”Application” AND if E =”Full”, AND if Columns F,L,M, N and O are not blank, then “Yes”Otherwise “No”

This is the formula I wrote that is returning the error

=IF(OR(AND(A14<TODAY(),C14 =”Internal”,D14=”A-11″,E14=”Modified Screening Due”,F14<>””,N14 <>””,O14<>””)),”Yes”,

IF(or(AND(A14>TODAY(), C14=”Internal”,D14=”A-11″, E14=”No Screening Due”,F14<>””, O14<>””)),”Yes”,

IF(or(and(ISBLANK(a14), c14=”Internal”, D14=”Application”, E14=”Full Screening Due”, F14<>””, L14<>””, M14<>””, N14<>””, o14<>””)), “Yes”,

If(or(and(isblank(a14), c14=”External”, D14=”Application”, E14=”Full Screening Due”, F14<>””,L14<>””, M14<>””, N14<>””, o14<>””)), “Yes”,

If(or(and <A14>TODAY(), C14=”External”, D14=”A-11″, E14=N “No Screening Due”, F14<>””, o14<>””)), “Yes”,”No”))

Help :-(.  I’m Googled and Binged out.

Thank you

​I am learning how to do formulas with multiple conditions in Excel, so by no means an expert.  I am trying to write a formula that accounts for 5 multiple conditions and I keep getting an error message. Summary:Column A is a date fieldColumn C has values of External or InternalColumn D has values of Application or No ApplicationColumn E has values of Not Due, Full and ModifiedColumns F, L-O can have date values or be blank, but the presence of a date drives the outcome.Scenario I’m trying to write the formula for:If the date in Column A < today’s date AND if C is “Internal” AND If D =”No Application” AND if E =”Modified”, AND if Columns F, N and O are not blank, then “Yes” ORIf the date in Column A > today’s date AND if C is “Internal” AND If D =”No Application” AND if E =”Not Due”, AND if Columns F, and O are not blank, then “Yes” ORIf the date in Column A is blank AND if C is “Internal” AND If D =”Application” AND if E =”Full”, AND if Columns F, L, M,N and O are not blank, then “Yes” ORIf the date in Column A > today’s date AND if C is “External” AND If D =”No Application” AND if E =”No”, AND if Columns F, and O are not blank, then “Yes” ORIf the date in Column A < today’s date or blank AND if C is “External” AND If D =”Application” AND if E =”Full”, AND if Columns F,L,M, N and O are not blank, then “Yes”Otherwise “No”This is the formula I wrote that is returning the error =IF(OR(AND(A14<TODAY(),C14 =”Internal”,D14=”A-11″,E14=”Modified Screening Due”,F14<>””,N14 <>””,O14<>””)),”Yes”,IF(or(AND(A14>TODAY(), C14=”Internal”,D14=”A-11″, E14=”No Screening Due”,F14<>””, O14<>””)),”Yes”,IF(or(and(ISBLANK(a14), c14=”Internal”, D14=”Application”, E14=”Full Screening Due”, F14<>””, L14<>””, M14<>””, N14<>””, o14<>””)), “Yes”,If(or(and(isblank(a14), c14=”External”, D14=”Application”, E14=”Full Screening Due”, F14<>””,L14<>””, M14<>””, N14<>””, o14<>””)), “Yes”,If(or(and <A14>TODAY(), C14=”External”, D14=”A-11″, E14=N “No Screening Due”, F14<>””, o14<>””)), “Yes”,”No”)) Help :-(.  I’m Googled and Binged out. Thank you  Read More

​