# Formula Error

#### Pyrrhus272BC

##### New Member
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")))))))

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### cameron.richens

##### New Member
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

##### New Member
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

##### New Member
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")

Last edited:

#### Pyrrhus272BC

##### New Member

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

##### New Member
Yes that is correct

#### Pyrrhus272BC

##### New Member

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

Yes that is correct

#### cameron.richens

##### New Member
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 **

Last edited:

#### Pyrrhus272BC

##### New Member
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"

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 **

Replies
1
Views
62
Replies
0
Views
535