An applicant is eliminated from further evaluation if ANY of the following is true: GPA is less than 2.5 The applicant provided less than 2 references

The applicant scores less than 700 on the Excel Test AND the applicant has an interview rating of 7 or less The applicant is not flexible for travel. (Recorded on Excel as 1 for YES and 0 for NO) The applicant changed jobs more than 3 times during the last 5 years.

In Column K, create a formula using the criteria listed above to determine those applicants who will be automatically eliminated.

PLEASE HELP WITH FORMULA