Formula Error

[Pyrrhus272BC]

All,

Any idea why my result comes back "FALSE"? As usual it seems like somewhere in this my parantheses are making problems. I also checked, and I am not exceeding the 7 nested statement rule

=IF(OR(E8="Revolver",E8="Term Loan"),IF(AD8<98,"Out",IF(OR(G8="MID CORP CORE",G8="MID CORP NON CORE"),"Out",IF(OR(E8="Global Umbrella Facility",E8="Uncommitted Loan"),IF(AT8="No","Out",IF(AW8="Y","Out",IF(ISBLANK(AX8),"Out","In")))))))

 

[cameron.richens]

you have not ended your first IF...

=IF(OR(E8="Revolver",E8="Term Loan"),IF(AD8<98,"Out",IF(OR(G8="MID CORP CORE",G8="MID CORP NON CORE"),"Out",IF(OR(E8="Global Umbrella Facility",E8="Uncommitted Loan"),IF(AT8="No","Out",IF(AW8="Y","Out",IF(ISBLANK(AX8),"Out","In")))))),"Out")

 

[Pyrrhus272BC]

No dice. The argument was finished with the last statement, however, I tried your suggestion which returned "False"

you have not ended your first IF...

=IF(OR(E8="Revolver",E8="Term Loan"),IF(AD8<98,"Out",IF(OR(G8="MID CORP CORE",G8="MID CORP NON CORE"),"Out",IF(OR(E8="Global Umbrella Facility",E8="Uncommitted Loan"),IF(AT8="No","Out",IF(AW8="Y","Out",IF(ISBLANK(AX8),"Out","In")))))),"Out")

 

[cameron.richens]

Ok missed that one too... remember each if statement needs a yes and a No answer... so there should be 7 Yes and 7 No answers in this Formula as there are 7 if's

=IF(OR(E8="Revolver",E8="Term Loan"),IF(AD8<98,"Out",IF(OR(G8="MID CORP CORE",G8="MID CORP NON CORE"),"Out",IF(OR(E8="Global Umbrella Facility",E8="Uncommitted Loan"),IF(AT8="No","Out",IF(AW8="Y","Out",IF(ISBLANK(AX8),"Out","In"))),"Out1"))),"Out2")

 

[Pyrrhus272BC]

Ok, I am testing this now. Just so I am clear, the first "Out1" corresponds to the Gold section?
The second "Out2" corresponds to the blue section?

Ok missed that one too... remember each if statement needs a yes and a No answer... so there should be 7 Yes and 7 No answers in this Formula as there are 7 if's

=IF(OR(E8="Revolver",E8="Term Loan"),IF(AD8<98,"Out",IF(OR(G8="MID CORP CORE",G8="MID CORP NON CORE"),"Out",IF(OR(E8="Global Umbrella Facility",E8="Uncommitted Loan"),IF(AT8="No","Out",IF(AW8="Y","Out",IF(ISBLANK(AX8),"Out","In"))),"Out1"))),"Out2")

 

[cameron.richens]

Yes that is correct

 

[Pyrrhus272BC]

Something still seems flawed, as I should not return every line to be OUT.

Yes that is correct

 

[cameron.richens]

remember it goes

=IF({Sum},Yes,NO)

{TIP} try doing each IF in a seperate cell and see if they work before you create a Super IF

Also "*TEXT*" will give you a positive result if the word TEXT is within a string of text due to the Stars **

 

[Pyrrhus272BC]

Thanks for the help. I didn't see the part about closing the statements off, however, the last parts should be "IN" because it is the false for each statement. The true is "OUT"

Appreciate your input.

remember it goes

=IF({Sum},Yes,NO)

{TIP} try doing each IF in a seperate cell and see if they work before you create a Super IF

Also "*TEXT*" will give you a positive result if the word TEXT is within a string of text due to the Stars **