Formula Error

Pyrrhus272BC

New Member
Joined
Mar 17, 2011
Messages
17
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")))))))
 

Some videos you may like

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
Joined
Nov 12, 2010
Messages
24
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
Joined
Mar 17, 2011
Messages
17
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
Joined
Nov 12, 2010
Messages
24
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
Joined
Mar 17, 2011
Messages
17

ADVERTISEMENT

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
Joined
Nov 12, 2010
Messages
24
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
Joined
Mar 17, 2011
Messages
17
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 **
 

Watch MrExcel Video

Forum statistics

Threads
1,109,322
Messages
5,528,007
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top