Getting rid of false result from nested if statements

hi there. always provide a sample excel file so it's easier for us to see. right now, we have to guess what values your cells has. we are also assuming the logic of the formula is correct.

I just want that if all of these statements are true, I want it to say Continue To calculator instead of false

i'm not sure if you are trying to say if all of the CELLS are showing TRUE, then show "Continue to calculator". because if you are saying statements being true, then the first IF would have already show it as "Pending".
=IF(H11=FALSE,"Pending"
the above formula is saying if cell H11 is equals to FALSE, show as "Pending". so if cell H11 is FALSE, it is asking if FALSE is equals to FALSE. it is of course TRUE and shows "Pending". since your result is showing FALSE, i doubt you are referring to this.

you also used OR in your formula, so i assume you know how to. so isn't it possible to group many of them in an OR? for eg.
=IF(OR(H11=FALSE,H13=FALSE,H15=FALSE,H17=FALSE,O13=FALSE,O15=FALSE,O17=FALSE),"pending")

your problem probably lies here:
...IFERROR(IF(VLOOKUP(L5,'Alpha List'!C8:C252,1,FALSE)=L5,"Prohibited Merchant",),IF(AND(OR(T3="Sole Proprietor",T3="Partnership"),V11=FALSE),"Continue To Calculator")),....
but i would have to look in your file and also understand your criteria in layman's terms. it seems like you want to check if a certain value appears in another worksheet. you just need to use Countif for that. and if they can't be found, it will be False because of your IFERROR.

Dissecting this it looks like:

- If any of H11,H13,H15,H17,H19,O13,O15,O17,V13,V15,V17 are FALSE then the status is "Pending"
- If V11 is FALSE and T3 is one of "LLC","Government","Corporation","Nonprofit/Tax Exempt","Association/Estate/Trust" then the status is "Pending"
- If L5 appears in 'Alpha List' C302:C308 then is W7 is "Yes" the status is "Prohibited Merchant" otherwise "Continue To Calculator"
- If L5 appears in 'Alpha List' C8:C252 then the status is "Prohibited Merchant"
- There is a final check for V11 being false and T3 one of "Sole Proprietor","Partnership" which sets the status to "Continue To Calculator" but that seems overkill because that's now the default result.

However, if the above is correct then perhaps try the following:

Please Login or Register  to view this content.

Hard to test without having actual examples to hand ...

WBD

Great! If you're happy with the solution, please mark the thread as solved. Two things:

- ISNUMBER(MATCH()) is just checking whether the item is in the list; it's common way to do this check and probably better than VLOOKUP.
- The multiplication is done on the all the Boolean values (TRUE/FALSE). Anything multiplied by FALSE will be zero so if any of those values are FALSE, the calculation will return 0.

WBD

Not sure where you wanted that check:

Please Login or Register  to view this content.

WBD

Thread now marked unsolved.