helfp with an "if and" with a vlookup

[Pumpk1n]

I need some help with parenthesis for an "if/and" formula.

=IF(and(VLOOKUP(D5,'Eligibility'!$C$5:$H$100,6,FALSE)="YES",(T5>=10%)),"Yes", else if (s5>=10% and (VLOOKUP(D5,'Eligibility'!$C$5:$H$100,6,FALSE)="No","Yes")),"No")))))

 

[CalcSux78]

When working with a messy nested IF statement, try writing it out in little blocks and piece it together.

IF(AND(TEST1,TEST2),[value if true],IF(AND(TEST1,TEST2),[value if true],[value if false]))

In the above example, the second IF statement would be the "value if false" portion of the first IF statement.

 

[Pumpk1n]

I'm still having issues
=IF(and(vlookup(s10,'Step2-BM Eligibility'!$C$5:$H$100,6,FALSE)="YES"),T10>=10%),"Yes",IF(and(vlookup(s10,'Step2-BM Eligibility'!$C$5:$H$100,6,FALSE)="No"),s10>=10%,"Yes"),"No"))))
IF(AND(TEST1, TEST2),[value if true],IF(AND(TEST1,TEST2),[value if true],[value if false]))

When working with a messy nested IF statement, try writing it out in little blocks and piece it together.

IF(AND(TEST1,TEST2),[value if true],IF(AND(TEST1,TEST2),[value if true],[value if false]))

In the above example, the second IF statement would be the "value if false" portion of the first IF statement.

 

[CalcSux78]

=IF(AND(VLOOKUP(S10,'Step2-BM Eligibility'!$C$5:$H$100,6,FALSE)="YES",T10>=10%),"Yes",IF(AND(VLOOKUP(S10,'Step2-BM Eligibility'!$C$5:$H$100,6,FALSE)="No",S10>=10%),"Yes","No"))