Forum Discussion

velicew's avatar
velicew
Copper Contributor
Oct 13, 2024
Solved

Problem with formula for multiple conditions

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 messa...
excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Oct 14, 2024

    velicew 

    =IF(OR(AND(A14<TODAY(), C14="Internal", D14="No Application", E14="Modified", F14<>"", N14<>"", O14<>""), AND(A14>TODAY(), C14="Internal", D14="No Application", E14="Not Due", F14<>"", O14<>""), AND(ISBLANK(A14), C14="Internal", D14="Application", E14="Full", F14<>"", L14<>"", M14<>"", N14<>"", O14<>""), AND(A14>TODAY(), C14="External", D14="No Application", E14="No", F14<>"", O14<>""), AND(OR(A14<TODAY(), ISBLANK(A14)), C14="External", D14="Application", E14="Full", F14<>"", L14<>"", M14<>"", N14<>"", O14<>"")),"Yes","No")

     

    The formula is untested.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

SnowMan55's avatar
SnowMan55
Bronze Contributor
Oct 14, 2024

velicew 

Toward the end of your formula, note "If(or(and <A14>TODAY()…"; the AND function is not properly formed, and I think the OR function should be nested within the AND, not vice versa.

 

But if you are using Excel 2021 or a later version, I recommend that you not try to put everything into nested IF functions; instead use the LET function to evaluate for each rule more clearly.  See the attached workbook.

 

Resources