IF/AND/OR Nesting

[RJB78]

Hello - I am looking to create a formula that will return 'YES' or 'NO' based on different factors.... Without going into detail on the other parts of the formula unless necessary, the entire formula works until I added the bolded section below.

=IFERROR(IF(AND((P81*0.075)>((RF!$AD$37*0.04)/$J81),E81<>"LP",VLOOKUP(A81,'TAB1'!A:W,23,FALSE)>0,OR(Data!BC81="A+","A","A-","B+","B","NR"),AY81>=0.045,BA81="Yes"),"Yes","No"),"No")

With this new bolded section of the formula, I wanted to only return 'YES' for the letter grades A+, A, A-, B+, B, NR. All other grades that still qualify from all other AND logicals would then return 'NO'.

Thank you in advance

 

[gaz_chops]

Try

OR(Data!BC81={"A+","A","A-","B+","B","NR"})

 

[RJB78]

Try

OR(Data!BC81={"A+","A","A-","B+","B","NR"})

That worked, thank you very much.

 

[gaz_chops]

You're welcome