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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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")
 
Upvote 0
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")
 
Upvote 0
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:
Upvote 0
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")
 
Upvote 0
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:
Upvote 0
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 **
 
Upvote 0

Forum statistics

Threads
1,216,415
Messages
6,130,461
Members
449,582
Latest member
Mengli

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
Back
Top