=IF(AND(G66=0,G75=0),”TEST SCORES NEEDED”,IF(AND(OR(G66>=L30,G75>=L31),OR(L25>=L27,(L25>=L28))),"QUALIFIER","NON-QUALIFIER"))
For my function, if the first portion (G66=0,G75=0) is TRUE, I need it to return "TEST SCORES NEEDED".
If the first portion (G66=0,G75=0) is FALSE, it should then use the nested if statement IF(AND(OR(G66>=L30,G75>=L31),OR(L25>=L27,(L25>=L28))),"QUALIFIER","NON-QUALIFIER")) to return either "QUALIFIER" or non "NON-QUALIFIER".
The second portion which returns "QUALIFIER" or "NON-QUALIFIER" is working properly, but I cannot get the first part of the function (G66=0,G75=0) to return "TEST SCORES NEEDED" if the (G66=0,G75=0) statement is true. When (G66=0,G75=0) is TRUE, it returns #NAME?.
Any ideas to help repair the first part of my If statement?
Bookmarks