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")))))))
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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 **
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,297
Messages
5,836,481
Members
430,434
Latest member
whatabout

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top