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.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
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.

velicew's avatar
velicew
Copper Contributor
Oct 14, 2024

NikolinoDE  Thank you so much.  That worked perfectly.  I appreciate it

Resources